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.


aaaaa said...

unfortunately this suggests it isn't possible:

David Appell said...