Settings changed for default cell format - want to change it back to general!

[yongson]

<!-- / icon and title --><!-- message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->Hi all !

I am having a little trouble with some of my excel spreadsheets: I am using some more or less complicated excel spreadsheet, where apparently all of a sudden all cells where formated as "accountig", which now looks a bit strange with all the dates and numbers beeing € amounts. But not only that, also when I open another sheet (for example by double-clicking a pivot-table or the conventional way) the whole new sheet is formatted with "accounting" as well.

Is there a way to change excels default format choice !? I wasn't aware of that, but suddenly it feels like . . .

Thank you very much in advance !

 

[Andrew Poulsom]

Have you tried looking at the Normal Style (Format|Style)?

 

[yongson]

What do you mean by format/style ? If we are talking about the "format cell" category "general" - everything is fine with that. It's just that in the number formatting area "Accounting" or "Date" is selected respectively.

HELP !

 

[Andrew Poulsom]

I assume you have Excel 2007, as your problem is well known:

http://office.microsoft.com/en-us/e...ove-a-cell-style-HP001216732.aspx#BMbasestyle