View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default how do i enter date and time in cell without it changing

To include both date and time in the same cell enter the shortcut
for the date then a space and then the shortcut for the time, and
it will be a legitimate Excel date and time.

More information on Date & Time in
http://www.mvps.org/dmcritchie/excel/datetime.htm
More information on keyboard shortcuts
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

If you want the timestamp entered automatically into an empty
cell when you fill in another cell see
http://www.mvps.org/dmcritchie/excel....htm#timestamp

And "bete" please don't use all caps or all lowercase as it makes
your post hard to read for those providing free help as well as
others who might also learn from your question. I've translated
for you. // David McRitchie, Microsoft MVP - Excel

"Paul B" wrote...
bete, Ctrl+; for date and Ctrl+shift+; for time

"bete" wrote ...
I want to use computer date and time in a cell in a worksheet but
I do not want it to change after a minute, I want it to stay as it was
first entered. Is this possible.