View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephen Quist Stephen Quist is offline
external usenet poster
 
Posts: 3
Default Can I format a number display with a fixed exponent?

Hi,

We have a group of cells we'd like to put in a variant of Engineering
notation.

These values, currents, range from several tens of nanoamps to a couple of
milliamps

For instance, we can easily set up the display to present the numbers as

12.34E-9
123.45E-9
1.23E-6
12.34E-6
123.45E-6
1.23E-3

and so on. Is there a formatting option that would present the numbers like
this?

..012345E-6
..12345E-6
1.2345E-6
12.345E-6
123.45E-6
1234.5E-6

Quite reasonably, the formatting insists on putting at least one non-zero
digit to
left of the decimal point. Is it possible to loosen this rule?

Thanks,

Steve