| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
