date problem in excel

New Contributor

Im having  a problem in excel . Im copying a table form one spread sheet to another, but when I do so the dates are changed to make them about 4 years earlier. 

I have seen a tutorial about how to fix this , but the first thing it says to do is open the file menu. 

But there is no file menu , or at least I cant find one. 

I would love to tell you which version of excel I am using, but i cant see anything that tells me that either. I have however attached an image of my screen, that I hope will help. I am running windows through parallels on a mac. Any tips most welcome. 

Screenshot 2023-01-10 at 13.05.17.png

4 Replies

@phalper 

Your screenshot shows that you are using Excel 2007. Instead of File, click the big Office button in the upper left corner.

Then select Excel Options at the bottom of the drop-down menu.

Select Advanced in the navigation pane on the left.

Scroll down to the section 'When calculating this workbook'.

Tick the check box 'Use 1904 date system'.

Click OK.

@Hans Vogelaar 

Thanks so much , that worked perfectly. 

Whilst I have you , how do I rename the document?

@phalper 

To rename the workbook, close it.

Then select the workbook file in Windows Explorer (aka File Explorer) and press F2.

Type the new name and press Enter.

thanks