Excel changed one of my cells format

[jevicha2]

I have a sheet I use for pricing (who doesn’t). I have a column for cost, selling price, then a calculated field to show profit in dollars, then a cell to show the percentage of profit. The percentage cell is formatted as a percentage cell with no decimals. When I enter a new item the percentage cell is change by Excel to an accounting format. I can click on the percentage blank cell before I enter a new item to make sure the percentage formatting is there and it is, but it gets changed. I have over 4500 items on my sheet. This only happens when I enter a new item. I also noticed that I can go anywhere within the sheet, insert a new row and enter a new item and that formula changes also, so must be something in the settings in Excel. I can drag down the formula but shouldn’t have to do this. Any clues as to why this is happening.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)