I have a list of 1,000 values 900 are numeric values and 100 of them are
text values. What problems could arise when working with this list? I
know sorting will not put part 1001 and 1001-ST together, but at one
time I recall VLOOKUP giving me a glitch when trying to pull data from
a list of numeric and text values.

Richard


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

<VLOOKUP giving me a glitch

Yes, and maybe many others.

If some of them contain letters, it is probably better to make them all text.

=text(a1,"0") or some other formatting string


--
Kind regards,

Niek Otten

"gacollege" wrote in message
...

I have a list of 1,000 values 900 are numeric values and 100 of them are
text values. What problems could arise when working with this list? I
know sorting will not put part 1001 and 1001-ST together, but at one
time I recall VLOOKUP giving me a glitch when trying to pull data from
a list of numeric and text values.

Richard


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

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