Have data that is a mix of number and text.
Ex: the field if PN
The data could be:
ABC123
123
AB23

I have formatted the column as TEXT, but if I use function isnumber(a2) for
value 123, it comes back TRUE.

I want 123 to be considered text; I'll be importing into Access.
What's my next step?

--
Eva H. Linich
Business Applications

Try putting an apostrophe before the numbers. This forces the cell to be
text.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544421

Try this:

Select your single column of values
<data<text-to-columns
[Next]
[Next]
Column format: Text
[Finish]

That should convert everything in the selected column of cells to text with
a number format of text.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Eva at Work" wrote:

Have data that is a mix of number and text.
Ex: the field if PN
The data could be:
ABC123
123
AB23

I have formatted the column as TEXT, but if I use function isnumber(a2) for
value 123, it comes back TRUE.

I want 123 to be considered text; I'll be importing into Access.
What's my next step?

--
Eva H. Linich
Business Applications

I will test this theory (sounds like it'll work) and advise.

Thx
--
Eva H. Linich
Business Applications



"Ron Coderre" wrote:

Try this:

Select your single column of values
<data<text-to-columns
[Next]
[Next]
Column format: Text
[Finish]

That should convert everything in the selected column of cells to text with
a number format of text.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Eva at Work" wrote:

Have data that is a mix of number and text.
Ex: the field if PN
The data could be:
ABC123
123
AB23

I have formatted the column as TEXT, but if I use function isnumber(a2) for
value 123, it comes back TRUE.

I want 123 to be considered text; I'll be importing into Access.
What's my next step?

--
Eva H. Linich
Business Applications