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

I'm not sure which problem you have.

1. When you create a new file, all cells are formatted to "accounting" by default
2. A specific that already exists had its formatting changed to "accounting"

How do you open a new sheet by clicking on a pivot table? Not sure what is happening to you there.

You may be able to troubleshoot by opening Excel Help and searching for the item entitled "Customize how Excel starts". That will only be helpful if your default workbook template has somehow been changed to have the formatting you described. I am not sure that is the problem, though.

Seems specific to your situation. Can you attach your file, plus the file with the pivot table source data?

Hi ! Good idea - I am attaching an example file containing only a little part of my data and analyses. You don't necessarily need to create the new sheet via clicking the pivot table - same issue (all cells formatted as accounting) when creating a new sheet manually.

Hope, someone can help me. Thanks in advance !

I'm sorry, I tried but I couldn't crack this one.

I created a new worksheet, and it came up just like you said, where every cell was formatted as Accounting.

Then I tried inserting a new worksheet by the context menu and selected Insert, and explicitly selected my default worksheet template, and it still came up formatted as Accounting. When I do the same thing on a workbook I create on my own machine, the cells are formatted as General.

I did not find anything in a web search to help. Sorry.....

Hi,

Our company is using MS Office 2010 and so is the Excel version.

I am living the exact same nightmare. And nightmare is a small work to express the disaster I am in.

I have created a lot of Excel tools for our sales rep that cannot be modified. They have a lot of sheets with mixed cell formatting.

All of a sudden, everything on every sheet came as Accounting with the "€" symbol. Hey I am down under in Australia! Why would I even have such a currency symbol in our spreadsheets?

I am testing one file and through all the sheets, every blank cell is formatted as Accounting instead of General.

When creating a new blank sheet, they are all formatted as accounting.

I cannot play around with trying to fix each and every sheet on these files. There are so many!

Is there a way to create a new sheet with the general format as default? I would think this could be set up in options, advanced options eventually but I can't find anything.

This is another Microsoft annoyance to add to the already long list...

Hi marcnz, welcome to the forum

Sorry to have to do this to you (again), but...
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.