Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
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
Import text to Excel Fredrik E. Nilsen Excel Discussion (Misc queries) 2 November 21st 05 06:55 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
how do I convert copied Text numbers into values in Excel? MOE Excel Worksheet Functions 1 June 14th 05 06:03 AM
setting text qualifier in Excel Lyle Excel Discussion (Misc queries) 1 June 8th 05 06:28 PM
Problems Autosaving an excel file/sheet as Text MaxFrance Excel Discussion (Misc queries) 0 March 25th 05 09:49 AM


All times are GMT +1. The time now is 05:51 AM.

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

About Us

"It's about Microsoft Excel"