Stop XL from changing format?

  • Thread starter Thread starter Joe User
  • Start date Start date
J

Joe User

I format a cell as Scientific with some number of decimal places. I enter
an NPV formula. The cell format is changed to Currency. I change the
format to Scientific again. I press F2, the Enter. The cell format reverts
to Currency.

Is there an option or Registry setting that will stop Excel from changing a
cell format, especially a non-General format?

I am using Excel 2003 SP3 (US).
 
Back
Top