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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals 1
Determine if night shift by start & end time 2
FORMULA NEEDED FOR MONTHS 1
Sorting and copying data to another worksheet in a workbook. 3
Default date format (with shortcut keys) 2
Sumproduct or ??? for non-same dimensions 3
SUMIF 3
Excel Formula Bar Time Display Format 2

Back
Top