all General formats of the workbook changed to date format suddenl

[Miri]

hi,
i'm working with excel 2007, did not change any definition of the style, and
susddenly all the "General" formats of the workbook changed to date.
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.

do you have any idea how to avoid it. do you have any idea how to solve the
spoiled the file?
thanks,
Miri

 

[loudfish]

hi,
i'm working with excel 2007, did not change any definition of the style, and
susddenly all the "General" formats of the workbook changed to date.
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.

do you have any idea how to avoid it. do you have any idea how to solve the
spoiled the file?
thanks,
Miri

If your file layout remains identical, open the last good copy (most
recent copy where the formats are OK), and copy.....
pastespecial...formats into the current worksheet. Work with copies to
test this please..........

Or fix it column by column (highlight the entire column, set the cells
formats for that column), assuming you have the same thing in each
column.

HTH

Andrew