| Home |
| Search |
| Today's Posts |
|
#1
Posted to 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 |
| 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) | |||
Linear Mode
