| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Dates
Everytime I open a worksheet, it updates the date. I don't want the created
date to change. How do I turn off this feature? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Dates
The date must be from =TODAY() or = NOW() which will update everytime the
sheet calculates. If you want a static date, just enter one, Regards, Alan. "mhashaw" wrote in message ... Everytime I open a worksheet, it updates the date. I don't want the created date to change. How do I turn off this feature? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Dates
Get rid of the formula...........probably looks like =TODAY()
Enter the date which is the date the workbook was created. In future, enter a static date by using CTRL + ;(semi-colon) CTRL + SHIFT + ; to enter the current time. Gord Dibben MS Excel MVP On Fri, 4 Apr 2008 09:05:01 -0700, mhashaw wrote: Everytime I open a worksheet, it updates the date. I don't want the created date to change. How do I turn off this feature? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel not recognizing dates as dates | Excel Discussion (Misc queries) | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
Linear Mode
