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.
Bookmarks