Hi,
there is a 'feature' of Excel (2003, SP2) that I'd like to turn off, but haven't found a way to.
I might, for example, have a value in 'scientific' format in cell A1. Now I may wish to 'echo' that value, or use it in a formula, say in cell B2. Suppose B2 is initially empty and has the (default) 'general' number formatting. Then entering "=A1" in B2 will make its number formatting switch automatically to 'scientific'.
Of course, this can be reverted, by manually changing B2 to 'general' number formatting. However it is frustrating to continually have to do this when copying or editing multiple cells. Furthermore, subsequent edits to the formula will cause the number formatting to again automatically switch to 'scientific'!
The same thing happens when entering "=A1/2" into B2, for example. It is _not_ because the value in A1 (or B2) is very large or very small: the value in A1 could be 1, and the above occurs — it only depending upon the number formatting.
When entering a formula referencing cells with a combination of number formats, it is unpredictable how the destination cell will be automatically changed, if at all!
Does anyone know how to turn this off??
Thanks,
- DIV
P.S. It only seems keen to override 'general' number formatting. Is there a custom number format I can create that is equivalent to 'general'. I know "#" can be used to have flexible significant figures, but sometimes (for large/small values) I _would_ want the formatting to be represented as scientific (as happens in the 'general' format)!
Bookmarks