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?

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?

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?