how to inset date in excel 07

[Guest]

How to insert date in excel cell

 

[Peo Sjoblom]

Type the date in a cell and press enter or do ctrl + ;

 

[Guest]

=now() - date and time
or ctrl and ; - just the date

 

[Guest]

You could also use the formula:

=Today()

Try this!!!

 

[Guest]

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?

 

[Roger Govier]

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