all dates in a column have gone back four years

B

benadem

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?
 
M

macropod

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.
 
S

Stefi

Check Tools>Options>Calculation tab>uncheck 1904 style dates
Regards,
Stefi


„benadem†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Find & replace different years (part of the date)in a column 1
how to automatically update a second worksheet when data inserted 2
Dates And Pivot Tables 1
count number of years 2003 in a range of dates 2
Excel Puzzle 2
COUNT IF BETWEEN DATES 7
Calculating dates 11

Top