Stop Excel auto formating

Question

How do I stop Excel from automatically formatting cells?&nbsp; I have three columns.&nbsp; The first column is formatted currency with fill.&nbsp; The second is text.&nbsp; The third is general.&nbsp; When tying a number in the general column Excel automatically formats the cell to currency with a fill matching the first column.&nbsp; How can I stop Excel from automatically changing the formatting of the cells in the third column?

jkpieterse · Answer

Normally Excel only extends formatting to cells in the same column. This is controlled by this setting in Excel options:&nbsp;&nbsp;

Forum Discussion

Stop Excel auto formating

1 Reply