Can I format a number display with a fixed exponent?

[Stephen Quist]

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

 

[Jason]

.<

You could always go dirty with something like:
=CONCATENATE(LEFT((+A1*1000000), 6), " E -06")

Good if you are doing it to make the data pretty for others to look at...but
it does convert it to text.

 

[Stephen Quist]

Thanks, we will give it a try. This may very well suit our needs.

Steve