Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text converts to scientific
Help!! I desparately need to import data from HTML (not available in any
other format). It is a mix of number and text references but anything with an E in the middle converts to scientific notation in Excel. Tried everything! converting to text, importing as a CSV, trying obscure fomulae on net suggested - nothing works. for instance want to import : 7211E50 and it comes in as 7.21E+53 any suggestions gratefully accepted .. I am not a VB person! A formula or method to convert to text that I can then record on a macro would be fabulous if it is possible? Seems ok in Word but the minute I bring it into Excel it goes to scientific again! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text converts to scientific
Preformat cells as Text. Copy your data and paste special select Text
"sally t" wrote: Help!! I desparately need to import data from HTML (not available in any other format). It is a mix of number and text references but anything with an E in the middle converts to scientific notation in Excel. Tried everything! converting to text, importing as a CSV, trying obscure fomulae on net suggested - nothing works. for instance want to import : 7211E50 and it comes in as 7.21E+53 any suggestions gratefully accepted .. I am not a VB person! A formula or method to convert to text that I can then record on a macro would be fabulous if it is possible? Seems ok in Word but the minute I bring it into Excel it goes to scientific again! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table converts to text | Excel Discussion (Misc queries) | |||
Converts number to text(in English words) | Excel Discussion (Misc queries) | |||
number converts to text | Excel Worksheet Functions | |||
Scientific notation in text cells | Excel Discussion (Misc queries) | |||
Using Excel converts number to english text | Excel Worksheet Functions |