Auto-formatting

[SammyB]

Excel is driving me crazy: I have a column E that has some custom formats and some % format. I want the column next to it to not have any formatting. I inserted three columns F, G & H, cleared all, cleared formats, and started entering numbers in the middle blank column. When I enter a number, it uses the format of that row in column E, and unless I clear that format, it continues to use that format. Which part of clear does it not understand??? Argggggggggg! I know that I must have something screwy in File > Options, but I cannot figure it out. It has something to do with the GEENERAL format: if I format that column as number with two decimals, then it doesn't use any other format. If I change back to GENERAL, then it does its guessing trick.

[HansV]

It's Excel trying to be helpful. To turn it off:
- Select File > Options.
- Select Advanced.
- Clear the check box "Extend data range formats and formulas" in the Editing section.
- Click OK.

S2180.png