Forum Discussion
date problem in excel
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 f...
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.
Thanks so much , that worked perfectly.
Whilst I have you , how do I rename the document?
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