| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to inset date in excel 07
How to insert date in excel cell
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Cell Inset? | New Users to Excel | |||
| Delete a row and inset a row - Lotus equivalent | Setting up and Configuration of Excel | |||
| inset rows and copy formatting , excel macro | Excel Discussion (Misc queries) | |||
Linear Mode
