View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jubu jubu is offline
external usenet poster
 
Posts: 8
Default 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