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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com