I've been working in several workbooks for the past couple of months with no problem. Then yesterday out of the blue I'm having problem every time I copy/past number from another sheet in the workbook or even from a workbook that I don't use very often, that it is always pasted in the Date Format, March 14, 2012. I've never had this happen before but it is very frustrating. I am attaching a file that shows a demonstration of it with more explanation.
Thanks!
To Repair a corrupted workbook
When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook:
Click File > Open.
Click the location and folder that contains the corrupted workbook.
In the Open dialog box, select the corrupted workbook.
Click the arrow next to the Open button, and then click Open and Repair.
To recover as much of the workbook data as possible, pick Repair.
If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook.
If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time.
I hope this information will be helpful to you!
Ben Martin