Shortcut for Exponetial

  • Thread starter Thread starter Bernard V Liengme
  • Start date Start date
B

Bernard V Liengme

By accident I found I can enter 4 million as 4**6. It gets formatted as
4.00E+06. Likewise 4**-6 give 4.00E-06.
Not sure if this is of any use but I thought I would share my 'discovery'
Bernard
 
That seems weird, actually
=4**6
get changed to
=4000000
so the it actually becomes a constant within the formula
 
Back
Top