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.

2 comments:

NnN said...

unfortunately this suggests it isn't possible:
http://office.microsoft.com/en-us/excel-help/display-numbers-with-scientific-notation-HP003064132.aspx

David Appell said...

Thanks.