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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text converted to scientific notations
< it immediately sends the data to excel
How? -- Kind regards, Niek Otten Microsoft MVP - Excel "jubu" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text converted to scientific notations
I'm actually asking this question on behalf of a friend. She indicated that
their mainframe system uses Crystal Reports, which immediately sends the data into excel format. She does not have access to the program to adjust how it sends the information, so she is looking for a solution once it is in excel. -- jubu "Niek Otten" wrote: < it immediately sends the data to excel How? -- Kind regards, Niek Otten Microsoft MVP - Excel "jubu" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text converted to scientific notations
No. Once Excel has stored it as a number, you can't restore the original
text. You'll have to change your process so that you get a text file from your mainframe. -- David Biddulph "jubu" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text converted to scientific notations
thanks! I suspected that, but thought it important to ask the experts!
Appreciate all your help. -- jubu "David Biddulph" wrote: No. Once Excel has stored it as a number, you can't restore the original text. You'll have to change your process so that you get a text file from your mainframe. -- David Biddulph "jubu" wrote in message ... 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 |
Reply |
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 |