I’ve been bitten by this automatic “helpful feature” a few times, and decided to track down what’s going on. Turns out that XL decides for itself that some data I enter should be converted to a percentage and that screws up my worksheet.
To demonstrate with a clean spreadsheet.
– enter numbers in three vertical cells (this behaviour does not appear with fewer than three rows of data)
– enter a number in the fourth row — everything is proper
– enter numbers into three vertical cells in a new column
– select the numbers, and apply the Percent format with the toolbar button
– enter a number in the fourth or fifth row
– XL changes the number to a Percent format
What’s worse is that the cell’s content is actually changed by a factor of 100. It’s not just a formatting problem.
– enter numbers into three vertical cells in a new column
– select the numbers, and apply the Percent format with the toolbar button
– enter a number in the sixth or subsequent row
– XL leaves the formatting and cell contents unaltered
Looking thru Tools > Autocorrect options, I found the “Include new rows and columns in list” setting and turned it OFF, to no avail. Did not find any other setting that seemed associated with this behaviour, so is there any way to disable this inconsistent behaviour? I would be quite happy for XL NOT to apply any automatic formatting, and let me decide for myself when I want a cell formatted.
I **really** wish that Microsoft would stop adding these erratic behaviours to its products. Is it too much to ask for consistent behaviour?
