| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel why does 4E01 change to 4.00E+01 whenever entered?
In excel why does 4E01 change to 4.00E+01 whenever entered?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel why does 4E01 change to 4.00E+01 whenever entered?
4E01 is scientific notation for 40 (4*10^1=4*10=40)
If you want to keep the cell showing 4E01 (as text), you can either preformat the cell as text or start your entry with an apostrophe: '4E01 Excel information...??? wrote: In excel why does 4E01 change to 4.00E+01 whenever entered? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
| Excel renames sheet (repaired) when trying to change data from a . | Excel Worksheet Functions | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Linear Mode
