Home |
Search |
Today's Posts |
#1
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
Hi
When formatting in Scientific, how can you keep the exponent constant and allow the decimal point to move? For example If I have: 6.647E-03 1.741E-02 8.378E-02 How do I ensure that Excel keeps the E to E-3 and adjust the decimal point? Cheers WayneL |
#2
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
On Sat, 07 Jan 2006 17:49:01 GMT, "WayneL"
wrote: Hi When formatting in Scientific, how can you keep the exponent constant and allow the decimal point to move? For example If I have: 6.647E-03 1.741E-02 8.378E-02 How do I ensure that Excel keeps the E to E-3 and adjust the decimal point? Cheers WayneL Don't use "Scientific", use "Engineering" notation. ...Jim Thompson -- | James E.Thompson, P.E. | mens | | Analog Innovations, Inc. | et | | Analog/Mixed-Signal ASIC's and Discrete Systems | manus | | Phoenix, Arizona Voice:(480)460-2350 | | | E-mail Address at Website Fax:(480)460-2142 | Brass Rat | | http://www.analog-innovations.com | 1962 | I love to cook with wine. Sometimes I even put it in the food. |
#3
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
I can't guarantee that it will always be to the -3, but I can guarantee that
it will be an "engineering" prefix that is some multiple of 3 (i.e. kilo, micro, pico, giga, etc.) Format the cell(s) in question with the Custom format of ##0.0E+0 (this is one of the predefined Custom formats). It wasn't my original idea; I think Jim Thompson showed me how to do it a few years ago. Jim "WayneL" wrote in message ... Hi When formatting in Scientific, how can you keep the exponent constant and allow the decimal point to move? For example If I have: 6.647E-03 1.741E-02 8.378E-02 |
#4
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
Could please let me know how to format in Engineering notation?
I have been in Format = Cell and there is not Engineering on Scientific. Cheers WayneL "Jim Thompson" wrote in message ... On Sat, 07 Jan 2006 17:49:01 GMT, "WayneL" wrote: Hi When formatting in Scientific, how can you keep the exponent constant and allow the decimal point to move? For example If I have: 6.647E-03 1.741E-02 8.378E-02 How do I ensure that Excel keeps the E to E-3 and adjust the decimal point? Cheers WayneL Don't use "Scientific", use "Engineering" notation. ...Jim Thompson -- | James E.Thompson, P.E. | mens | | Analog Innovations, Inc. | et | | Analog/Mixed-Signal ASIC's and Discrete Systems | manus | | Phoenix, Arizona Voice:(480)460-2350 | | | E-mail Address at Website Fax:(480)460-2142 | Brass Rat | | http://www.analog-innovations.com | 1962 | I love to cook with wine. Sometimes I even put it in the food. |
#5
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
On Sat, 07 Jan 2006 18:21:21 GMT, "WayneL"
wrote: Could please let me know how to format in Engineering notation? I have been in Format = Cell and there is not Engineering on Scientific. Cheers WayneL [snip] Format - Cells - Number - Custom ##0.0E+0 As Jim of RST reminded me. ...Jim Thompson -- | James E.Thompson, P.E. | mens | | Analog Innovations, Inc. | et | | Analog/Mixed-Signal ASIC's and Discrete Systems | manus | | Phoenix, Arizona Voice:(480)460-2350 | | | E-mail Address at Website Fax:(480)460-2142 | Brass Rat | | http://www.analog-innovations.com | 1962 | I love to cook with wine. Sometimes I even put it in the food. |
#6
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
Please let me know how to format in Engineering notation?
I have been in Format = Cell and there is not Engineering on Scientific. Cheers WayneL |
#7
Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
Please let me know how to format in Engineering notation?
I have been in Format = Cell and there is not Engineering on Scientific. Cheers WayneL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping the exponent at a fix value in Excel | Excel Worksheet Functions | |||
Keeping the exponent at a fix value in Excel | Excel Discussion (Misc queries) | |||
Keeping the exponent at a fix value in Excel | Excel Worksheet Functions | |||
Keeping the exponent at a fix value in Excel | Excel Discussion (Misc queries) | |||
Keeping the exponent at a fix value in Excel | Excel Worksheet Functions |