DATE format is defaulty showing in MS Excel 2007 for huge data

[chandra.pamidi]

Hi Friends,


In Excel 2007 - I have a large workbook with 15 worksheets.

All of a sudden every empty cell, and any cell not specically formated, in

every worksheet has a default cell format of Date. Every blank column and row

or any cell with not a specific format.


How did the default cell format for this workbook become set to 'Date' from

'General' and how do i fix it?


Any new workbook created is OK.. defaults to 'General' - But, if I add a new

blank worksheet to this particular workbook... it defaults to 'Date' format.


Can you please resolve this if you have idea.

 

[Hui]

I've never seen that occur by itself

It can happen if you have grouped pages and then applied a format to a large area

Do you have a back up ?

Otherwise it is all manual reformat