LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select Range based on column name and not A1 notations T.Vidak Excel Discussion (Misc queries) 3 July 16th 08 02:02 PM
Lookup text in 1 column and make notations in another Nordic Excel Worksheet Functions 1 May 3rd 08 08:58 PM
How do I stop Hexadecimal being converted wrongly to scientific? Steve Harvey Excel Discussion (Misc queries) 1 January 24th 07 02:17 PM
Scientific notation in text cells miles Excel Discussion (Misc queries) 3 December 7th 06 10:59 PM
Using scientific notation in TEXT() function boopathi Excel Worksheet Functions 1 October 10th 05 08:23 PM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"