| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing Dates in Excel
When I open a file, the dates keep changing to the current date. How do I
stop this? |
|
#2
|
|||
|
|||
|
It must be a formula (=TODAY()).
You need to input the dates (Ctrl-:), or use VBA to set them. What does the spreadsheet do? -- HTH Bob Phillips "Jackie" wrote in message ... When I open a file, the dates keep changing to the current date. How do I stop this? |
|
#3
|
|||
|
|||
|
When I open a file with a previous date it changes it to the current date. I
need to know how to turn it off so I can keep the previous date? "Bob Phillips" wrote: It must be a formula (=TODAY()). You need to input the dates (Ctrl-:), or use VBA to set them. What does the spreadsheet do? -- HTH Bob Phillips "Jackie" wrote in message ... When I open a file, the dates keep changing to the current date. How do I stop this? |
|
#4
|
|||
|
|||
|
I think that was what I answered.
-- HTH Bob Phillips "Jackie" wrote in message ... When I open a file with a previous date it changes it to the current date. I need to know how to turn it off so I can keep the previous date? "Bob Phillips" wrote: It must be a formula (=TODAY()). You need to input the dates (Ctrl-:), or use VBA to set them. What does the spreadsheet do? -- HTH Bob Phillips "Jackie" wrote in message ... When I open a file, the dates keep changing to the current date. How do I stop this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2000 crashes when changing fonts. | Excel Discussion (Misc queries) | |||
| Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
| Recognizing weekends and changing to weekdays in Excel | Excel Discussion (Misc queries) | |||
| Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
Linear Mode
