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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the exponent at a fix value in Excel
If it hasn't shown up yet in one of your other threads, Jon Peltier describes engineering notation here http://www.peltiertech.com/Excel/NumberFormats.html -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=499036 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Keeping date format of a field inserted from an excel database | Excel Worksheet Functions | |||
numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) |