how to inset date in excel 07
 

How to insert date in excel cell

how to inset date in excel 07
 

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


--
Regards,

Peo Sjoblom



"tse" wrote in message
...
How to insert date in excel cell

how to inset date in excel 07
 

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

"tse" wrote:

How to insert date in excel cell

how to inset date in excel 07
 

You could also use the formula:

=Today()

Try this!!!


"tse" wrote:

How to insert date in excel cell

how to inset date in excel 07
 

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

how to inset date in excel 07
 

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