scientific notation to display 1.8 x 10-5 in Excel

F

feloniousmoney

Can Excel display scientiic notation as, say 3.00 x 10-12 as opposed to the
number 3.00E-12?
 
D

Dave Peterson

How about a helper cell:

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

And you can use the original cell for calculations.
 

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

Scientific Notation 1
Custom cell format for Scientific Notation 4
how do you type scientific notation in Word 2003? 4
Can scientific notation be turned off? 1
Scientific Notation Truncation 5
Excel's localization of scientific notation 1
CSV and Custom Fields 6
How do I stop Excel 2007 from using scientific notation? 2

Top