Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
feloniousmoney
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 will not display color fonts or color fill cells DaveC Excel Worksheet Functions 1 April 11th 05 04:38 PM
Excel Compare values in columns & display missing values in a new cpetta Excel Discussion (Misc queries) 1 April 2nd 05 05:51 AM
Display Worksheet in Excel File Rowf Excel Discussion (Misc queries) 2 March 30th 05 10:16 PM
display data as a percentage of a subtotal in excel pivot table Fl pivot user Excel Discussion (Misc queries) 2 March 26th 05 01:24 PM
Display a pix from a URL in a Excel cell Pilot007 Excel Discussion (Misc queries) 1 December 27th 04 01:22 AM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"