So, I came across a spreadsheet that has roughly 6000 lines of information, some of which are dates. Trying to copy it into a new workbook, the dates shifted, and I realized it was a difference in the preference between the 1900 and 1904 year format (since excel uses these to forumlate the date). Is there any way I can change the format from 1904 to the standard 1900, without changing the dates on all 6000 lines, and if not, is there an easy way to bump the date by 4 years for all my entries?
Bookmarks