Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Display Worksheet in Excel File | Excel Discussion (Misc queries) | |||
display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
Display a pix from a URL in a Excel cell | Excel Discussion (Misc queries) |