All Excel Sheets Changed to date formet

Microsoft Office excel 2007 home & stude...
June 20, 2010 at 01:59:29
Specs: Windows XP, Microsoft Excel 2007
All the cells in my excel sheet have been changed to date format. Help!

See More: All Excel Sheets Changed to date formet

Report •

June 20, 2010 at 07:48:30
First thing to try:

Running Microsoft Office Diagnostics from within Excel

Click the Microsoft Office button

Click on the Excel Options button to bring up the Excel Options dialog box

Click on the Resources button in the left hand pane

Click on the Diagnose button in the right hand pane

Click Continue

Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button

Click All Programs

Click Microsoft Office folder

Click Microsoft Office Tools

Click Microsoft Office Diagnostics

Click Continue

Click Run Diagnostics

See if that helps.


Report •

June 21, 2010 at 22:43:21
THank you, but this didn't help.

Report •

June 22, 2010 at 03:49:31

Has this happened on only one workbook, or are all worksheets in all workbooks now formatted as Dates.

You said All the cells in my excel sheet have been changed. Are the cells on other worksheets in the same workbook also affected.

If the problem is affecting only one worksheet in one workbook, or even all worksheets in one workbook, but other workbooks are OK, then the problem is likely a corrupt workbook.

Was this a workbook you created or is it one that was sent to you. If it was sent to you, it is possible that it has some code embedded in it. Right-click the name tab of the affected worksheet. Select View Code and look at the large visual basic window to see if any code is present.
Now work through each of the objects under the workbook name on the left side under VBAProject(<MyWorkbook's name>.xls) . Double click each worksheet name and double click ThisWorkbook, then do the same for any Modules listed.

When you right-click on an affected cell, and select Format Cells... what format is shown in the Number section, Custom category - is it a date format or does it show 'General'

Can you re-format the cell as General - when you try this, does the cell return to a normal format.

What happens if you open a new empty workbook and copy one affected cell to the new workbook.
What does it show - is it formatted correctly or is it formatted as a date.


Report •

Related Solutions

June 22, 2010 at 06:08:35
Yes, the cells on other worksheets in the same workbook also affected. Only this workbook with all the worksheets got affected. This one was sent it to me but it was ok for couple of weeks then all of a sudden it changed. Yes the cells return to their respected format when I change them, the values also return. When I copy the affected cells to a new workbook it shows the same date format in the copied cells only. There is no code in the VB window.

Report •

June 22, 2010 at 07:43:05

From what you say, the problem is only in that one workbook. I would run it through your anti-virus program as a check, but I would still remove it from my system altogether.

I would also want to talk to the person who sent it to you, to see if they have had a similar problem.


Report •

October 21, 2010 at 08:05:01
This has been happening to me too. I have sheets that I've created. They would be working fine, then all of a sudden I'll open the sheet to find everything has changed to date format. I've recreated the sheets... I've gone to the cell styles and changed chose "Modify" to normal tab, then changed that to general... I've done everything suggested, and it still happens.

Five minutes ago, I was working on a sheet. All looked fine. Saved and closed. Opened it up a few minutes later to find all sheets went to Date Format. I just copied all sheets to a new workbook.


Report •

October 21, 2010 at 10:42:05
You could try opening in SAFE mode:

Click Start
Click Run
Type in: "C:\Program Files\Microsoft Office\Office\Excel.exe" /s
Click OK

See if you get the corruption while in safe mode.

What Safe Mode does is:

Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder,
the default XLStart folder located in the directory where Excel or Office is installed,
and the alternate startup file location specified on the General tab of the Excel
Options dialog box.
It also forces Excel to bypass the toolbar file (Excel.xlb or <username>.xlb).

You should see "Safe Mode" in the title bar.

You can also try a REPAIR
First open a new instance of Excel,
Then on the File menu, click Open.
In the Open dialog box, select the file you want to open,
and click the arrow next to the Open button.
Click Open and Repair, and then choose which method you want to use to recover your workbook.

You can also try saving them in a different format, like SYLK or HTML.
You may loose some formatting info, but hopefully you'll get your data.

Next time, ask your question in a new thread, helps keep things tidy.


Report •

Ask Question