Stop XL from changing format?
 

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).

Stop XL from changing format?
 

Hi Joe,

One way: wrap your formula in a VALUE function
=VALUE(YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Joe User" <joeu2004 wrote in message
...
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).