| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
all dates in a column have gone back four years
All the dates in every column containing dates on every page of an excel
document have suddenly gone back four years inexplicably. When I attempt to copy the correct dates from a saved copy of the same document, the four year old dates simply reappear. Why are these columns refusing to allow me to paste the dates I want? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
all dates in a column have gone back four years
Hi benadem,
Check the date system under Tools|Options|Calculation. Changing it to '1904 date system' will probably fix the problem. The 1904 date system is usually only used on Macs. -- Cheers macropod [MVP - Microsoft Word] "benadem" wrote in message ... All the dates in every column containing dates on every page of an excel document have suddenly gone back four years inexplicably. When I attempt to copy the correct dates from a saved copy of the same document, the four year old dates simply reappear. Why are these columns refusing to allow me to paste the dates I want? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
all dates in a column have gone back four years
Check ToolsOptionsCalculation tabuncheck 1904 style dates
Regards, Stefi €˛benadem€¯ ezt Ć*rta: All the dates in every column containing dates on every page of an excel document have suddenly gone back four years inexplicably. When I attempt to copy the correct dates from a saved copy of the same document, the four year old dates simply reappear. Why are these columns refusing to allow me to paste the dates I want? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating back 4 years | Excel Worksheet Functions | |||
| Check dates in spreadsheet against expiry years column and change colour | Excel Worksheet Functions | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| How to add 100 years to a column of dates | New Users to Excel | |||
| How do I Fill a column with dates (for 3 years of daily data) | Excel Discussion (Misc queries) | |||
Linear Mode
