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.