| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
