Prev: Time - Distance plot...
Next: Extremely slow processing
From: Joe User on 2 May 2010 10:13
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).

From: Niek Otten on 2 May 2010 10:23
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
news:enaTeGg6KHA.5016(a)TK2MSFTNGP02.phx.gbl...
>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).

 | 
Pages: 1
Prev: Time - Distance plot...
Next: Extremely slow processing