| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting imported cell from exponential form
Hello, I'm having trouble when I import data into Excel.
Any data including numbers and the letter "E" automatically appears in exponential form. For Example: 96E03 9.60E+04 96E003 9.60E+04 10E18 1.00E+19 10E018 1.00E+19 Is there a formula that can be applied to the cells and copied to make life easier? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting imported hr/min/sec to excel | New Users to Excel | |||
| How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
| imported text data converting to dates | Excel Discussion (Misc queries) | |||
| Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
Threaded Mode
