ExcelBanter - scientific notation to display 1.8 x 10-5 in Excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - scientific notation to display 1.8 x 10-5 in Excel (https://www.excelbanter.com/new-users-excel/34138-scientific-notation-display-1-8-x-10-5-excel.html)

feloniousmoney

scientific notation to display 1.8 x 10-5 in Excel

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

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.

feloniousmoney wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 06:08 PM.