Thread: Inserting time inside cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Inserting time inside cell
Hi Sachi,

Not sure if this is what you are looking for but if you
hit ctrl+; in a cell it will put the current date in that cell,
if you hit ctrl+shift+: it will put the current time in that cell.

HTH
Martin


Reply With QuoteReply With Quote