View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
elwilliamson elwilliamson is offline
external usenet poster
 
Posts: 2
Default Can I format numbers using engineering notation in excel?

Is there a way to format numbers in excel in engineering format where the
exponent is always a multiple of 3?

Examples
2.6e3
34.7e-9
But not 3.47e-8