Hi Bart

Typing Ctrl +; (that's Control + Semicolon) inserts the current date as a
fixed value in a cell

Control + Shift + Semicolon (i.e Ctrl+Colon Ctrl+:) inserts the current
time

--
Regards
Roger Govier



"Bart" wrote in message
...
When I do this it updates the time/date in all cells (using it to track
task
start and stop times). How do I limit the update to just the cell I have
selected?

"Sameer Nagi" wrote:

You could also use the formula:

=Today()

Try this!!!


"tse" wrote:

How to insert date in excel cell