Note added 7/18/12: I have found a partial solution, as I explain here.
Friday, July 01, 2011
Excel Bleg
In MS Excel, if you enter a formula like =A1/1e9 into a cell, Excel displays it in the formula bar as =A1/1000000000 . Is there a way to force Excel to keep the scientific notation in the formula bar? I haven't been able to find one, and the large amount of zeros make such things difficult to proofread. Thanks.
Note added 7/18/12: I have found a partial solution, as I explain here.
Note added 7/18/12: I have found a partial solution, as I explain here.
Subscribe to:
Post Comments (Atom)
1 comment:
unfortunately this suggests it isn't possible:
http://office.microsoft.com/en-us/excel-help/display-numbers-with-scientific-notation-HP003064132.aspx
Post a Comment