Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Make the check that Dave Peterson recommended.
Can you manually change the data back to the correct types? If you can, then you can first choose all cells and change their data type to General and begin the tedious task of changing what you currently have to the proper data types. You haven't actually lost your data, just the way it appears, so changing the format will get things back to the way you need them to be. "Eddie" wrote: I am using Excel 2007. I have a worksheet filled up with some number, currency and date. It was working fine all this while. Just recently, when I open that file. All the cells format change to date format. This is included blank columns or rows. Its screw up all the data... May I know why is it happen and how to rescue my file? Thank you Eddie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DATE FORMAT CHANGE FROM EXCEL WORKSHEET TO PIVOT TABLE | Excel Discussion (Misc queries) | |||
I want to copy rows with values 0 to another worksheet automatica | Excel Worksheet Functions | |||
Format Cells Date (or any change) not working on imported data | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) |