Excel 2007 formats whole work book in date format unexpectedly

[Alex Valencia]

This happened to me a few times now. In a huge workbook unexpectedly one finds that practically the whole workbook has formatted each cell as a date. Depending on the nature of the info in each cell, I have needed to change some back to what I need. Problem solved?...Not really.


I open the file again and the date format problem is back. Is there a way to solve or avoid this permanently?

 

[Hui]

Alex


A few things to look at


Is there a VBA subroutione in the file doing this every time you open it?


Do other people have access to the file, are they doing it for other purposes?


Is it an Excel 2007 file (*.xlsx or *.xlsb file type) or are you importing a 2003 or other format file?

 

[Alex Valencia]

Well, I am an accountant, not an excel expert so I do not know what a VBA subroutine is. I can tell you that it is an excel 2007 file. However, it has some spreadsheets that come from the previous version on excel.


Also, the file does include a spreadsheet that was sent to me by my corporate financial department showing specific information for comparison purposes. I know that the origin of this spreadsheet is not excel and I am not using it anymore. Could this be the problem?


Regards!

 

[Meedan]

HUI meant to ask is there any Macro in the worksheet which converts all the Cell to date format upon opening.


I have heard similar problems faced by my colleagues in Excel 2007. Below are some solution might be they help.


(Excel 2007)

Select the entire workbook - (Ctrl + A - 2-3 times)

Go to Home tab

In Styles - Click on 'Cell Styles'

Right Click on 'Normal'

Select the 2nd Option 'Modify'.

From Context Menu - Select Format

Select General. ( In case it is selected then choose the Number tab and then again select General.). Press OK OK.


Again goto Cell Styles - Left Click on Normal. (Right CLick Apply)


Save the file. & Again reopen it. I hope the problem might get solved.


In case not, please share the file here.