View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Melinda Chase
 
Posts: n/a
Default Custom format for scientific notation

Thanks! I doubt we'll ever reach the billions, so I think we're safe
using this format. Whew, these are too complicated!
Melinda

JE McGimpsey wrote:
As long as you don't have any values greater than or equal to 1E9, you
can fake it:

Format/Cells/Number/Custom [<1000000]\0\.000000\E+6;##0.000000E+0