When I insert a worksheet the cell format is accounting

Greetings all, I am hoping someone can help me with this.

I am working with an xlsx file in Excel 2010 and every time I right click and Insert Worksheet the cell format is set to Accounting by default. How can I fix it so when I insert a new worksheet the cell format is General by default?

Thanks in advance!

This one particular file that I am working in is the only one where this formatting issue happens. Every other excel file has the general cell format as the default.

Ron - Yes, the number style is accounting and I want that removed. Every time I create a new worksheet it says "Accounting" in the number section of the ribbon

In the cells section of the ribbon there is just Insert, Delete, and Format. Where can I find the Cell Styles function?

In the styles section there is just the conditional formatting button, format as a table button, and a bunch of "20% Accent" buttons. The usual style sections with Good/Bad/Neutral, Data and Model, Titles and Headings, etc is not available. As such, there is no "Normal" for me to select. I have attached a picture of my ribbon.

Image 2.jpg

Originally Posted by Ron Coderre

I see the problem...Excel's ribbon automatically adjusts to take "best" advantage of the available real estate. On mine, the Cell Styles are collapsed. On yours, they're expanded

• Click: the "More" button in the Cell Styles section...the entire window will expand.
then you can right-click on Normal.

That's just the thing, even when I hit "more" it is just all the same format and none of the usual formats are in there. Whoever created this file initially really screwed it up.

BTW, Ron I appreciate you taking the time to try and help me on this.

YES! That worked!

Many thanks Ron.