View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Custom cell format for Scientific Notation

Take a look he

http://people.stfx.ca/bliengme/Excel...and_Charts.htm

and download the file.

Hope this helps.

Pete

On Aug 17, 11:52*pm, jmac wrote:
I want to create a cell format for scientific notation as follows 1.0 x 10-7,
preferably with the -7 as a super-script. I can't figure out how to get rid
of the E (or e) that Microsoft wants to use by default in any scientific
notation. Hope someone can help!

Thanks!