View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gacollege
 
Posts: n/a
Default Problems with Text values in Excel.


Niek Otten Wrote:
<If some of them contain letters, it is probably better to make them all
text


I kind of was thinking that..but from what little I have read - if you
take a data dump from a .txt file and convert to Excel - you have to
rekey the text values. Which defeats the beginning purpose. In
addition - I think the sort function will become void at this point?

At this point upper management (not fluent in Excel) is looking at
dumping a lot of text data into numeric data and I am concerning this
will cause havic on any Excel spreadsheets that I may have.

Richard



--
gacollege
------------------------------------------------------------------------
gacollege's Profile: http://www.excelforum.com/member.php...fo&userid=1518
View this thread: http://www.excelforum.com/showthread...hreadid=521639