Default Currency format overidden when inserting a new row
I maintain a spreadsheet table ordered by date from newest to oldest. I use a hidden formatting row (3) below the header to support inserting new rows at the top. There are a number of currency rows formatted as Currency. Lately, when I insert a new row at the top or anywhere below there, two columns (F and G) in the new row default to the Accounting format, forcing me to manually fix those two cells. This formatting causes the cell to override the default format an display the data centered horizontally and the $ sign is spaced further left of the currency value. Earlier, the file cache has been emptied and Office 365 has been reset. Neither procedure fixed the issue. What is causing this and how do I fix it? See attachment.
|