enter date&time into cell

  • Thread starter Thread starter Valdemar
  • Start date Start date
V

Valdemar

Hello to all,
please help me.
How can I enter actual date&time into cell using keybord? I need to prepare
a simple sheet for evidence of events and I'd like to allow to users to enter
this data.
Many thanks and have a good day. Valdemar
 
EXCEL 2007

MS documentation says:-

to insert the current date and time, press CTRL+; (semi-colon), then press
SPACE, and then press CTRL+SHIFT+; (semi-colon).

Please hit Yes if my comments have helped.

Thanks.
 
Hi Russell,
I know about this function CTRL+; (semi-colon) and CTRL+SHIFT+;
but in my Excel (version 2003) it works only for date CTRL + ;
and not for time:-(( SA
So I'll use macro.
Thank you for your time, Valdemar.



Russell Dawson píše:
 
Back
Top