Just a guess...

Excel workbooks can have styles. If you changed the Normal style (by accident),
you could have changed all the cells that are using that Normal style.

In xl2003 menus, it's under:
Format|style|Normal (chosen from the dropdown)

I think that in xl2007, it's on the Home tab|Style Group (I _think_)

B Smith wrote:

Using Excel 2007 - I have a large workbook with 23 worksheets - been using it
for years and have succesfully converted to .xlsx format for a long time and
use it every day.

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.

Thanks in advance for any guidance.

B Smith

--

Dave Peterson