Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
all the general formats of the workbook suddenly changed to date.
hi,
i'm working with excel 2007, did not change any definition of the style, and susddenly all the formats of the workbook changed to date. do you have any idea how to avoid it. do you have any idea how to solve the spoiled the file? thanks, -- Miri Tz. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
all the general formats of the workbook suddenly changed to date.
If you feel this is happening due to style then select the range and apply
normal style. If your file format is not restored then this may be because of something else. (May be u have selected all cells and applied date format) Try your backup file or opening ur original file in excel 2003 and then saving again "Miri" wrote: hi, i'm working with excel 2007, did not change any definition of the style, and susddenly all the formats of the workbook changed to date. do you have any idea how to avoid it. do you have any idea how to solve the spoiled the file? thanks, -- Miri Tz. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
all the general formats of the workbook suddenly changed to da
what do you mean apply normal style?
my range includes several types: Dates, numbers, general... only the general formats changed into date. i can not change the whole range to general since the real dates will be dispalyed not ok. the file is very big, i can not change it cell by cell. i'm looking for general solution. (i have not selected the range and set it to Date... in this case i would'nt ask for the reason... :-)) -- Miri Tz. "Prashant Runwal" wrote: If you feel this is happening due to style then select the range and apply normal style. If your file format is not restored then this may be because of something else. (May be u have selected all cells and applied date format) Try your backup file or opening ur original file in excel 2003 and then saving again "Miri" wrote: hi, i'm working with excel 2007, did not change any definition of the style, and susddenly all the formats of the workbook changed to date. do you have any idea how to avoid it. do you have any idea how to solve the spoiled the file? thanks, -- Miri Tz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all the general formats suddenly replaced with date format. | Excel Discussion (Misc queries) | |||
sheet background color suddenly changed to light green from normal | Excel Discussion (Misc queries) | |||
MS Excel 2007 file default general is changed to date, very annoying, please help? | Excel Worksheet Functions | |||
Cell format has suddenly changed in all new spread sheets | Excel Discussion (Misc queries) | |||
excel date formats changed | Excel Worksheet Functions |