LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS Peter Excel Discussion (Misc queries) 7 January 23rd 07 05:18 PM
Number format than does not display zeros after the deciaml point Nic Excel Discussion (Misc queries) 0 November 20th 06 02:16 PM
Number format need to display 0001 etc Carys Excel Discussion (Misc queries) 4 July 27th 06 07:22 PM
display a number that is decimal degrees in Deg:min:sec format Sterling Excel Discussion (Misc queries) 1 December 18th 05 12:50 AM
Can I fix the exponent in scientific/engineering format? MrShorty Excel Discussion (Misc queries) 1 June 27th 05 08:12 PM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"