scientific notation to display 1.8 x 10-5 in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can Excel display scientiic notation as, say 3.00 x 10-12 as opposed to the
number 3.00E-12?
 
How about a helper cell:

=SUBSTITUTE(TEXT(A1,"0.00E+00"),"E"," x 10")

And you can use the original cell for calculations.
 
Back
Top