If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom format for scientific notation
Hello,
I have a spreadsheet in which I would like one value to always be displayed in scientific notation with E6. The number gets put into a nomograph which uses values in the millions, so it's easiest to see if my value is written this way. Example: 1,234 would display as 0.001234E6 I've tried ##0.00E0, but if the value is less than 100,000 it displays as E3. Any ideas? Thanks! Melinda |
#2
|
|||
|
|||
Custom format for scientific notation
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 In article , "Melinda" wrote: Hello, I have a spreadsheet in which I would like one value to always be displayed in scientific notation with E6. The number gets put into a nomograph which uses values in the millions, so it's easiest to see if my value is written this way. Example: 1,234 would display as 0.001234E6 I've tried ##0.00E0, but if the value is less than 100,000 it displays as E3. Any ideas? Thanks! Melinda |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Reference Cell in custom format???? | lil_ern63 | General Discussion | 3 | September 1st, 2005 02:27 PM |
Custom percent format needed | Will Fleenor | Worksheet Functions | 1 | June 29th, 2005 02:57 AM |
Cell will not format numbers correctly for a 13 digit custom barc. | Laudan | Worksheet Functions | 4 | April 11th, 2005 08:13 PM |
How can I force capitalization in a custom date format in Access? | spkelly | General Discussion | 4 | December 11th, 2004 12:57 PM |