Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text converted to scientific notations
I read the threads about numbers coming through as scientific. Most of the
suggestions were to change the format of the cell. However, my situation is such that when we download information from our mainframe, it immediately sends the data to excel - we are unable to use the import wizard to request that the desired column remain as text, which would eliminate the scientific notation problems. Is there anything that can be done to the column after the data is in place, to "recover" the original number? -- jubu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Range based on column name and not A1 notations | Excel Discussion (Misc queries) | |||
Lookup text in 1 column and make notations in another | Excel Worksheet Functions | |||
How do I stop Hexadecimal being converted wrongly to scientific? | Excel Discussion (Misc queries) | |||
Scientific notation in text cells | Excel Discussion (Misc queries) | |||
Using scientific notation in TEXT() function | Excel Worksheet Functions |