Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop time format changing when I merge cell contents? | Excel Worksheet Functions | |||
Stop Excel Changing Format | Excel Worksheet Functions | |||
how to stop general format automatically changing to custom | Excel Discussion (Misc queries) | |||
How do I stop excel from changing my ratios into time format? | Excel Discussion (Misc queries) | |||
How do I stop 5/6 changing to 5/6/05? | Excel Discussion (Misc queries) |