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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting imported cell from exponential form
When you import the data, tell the Import Wizard that the field is Text.
-- Gary''s Student - gsnu200770 "Katie Mac" wrote: 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 |
Reply |
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) |