software

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: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=544421Try this:

Select your single column of values
lt;datagt;lt;text-to-columnsgt;
[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, WinXPquot;Eva at Workquot; wrote:

gt; Have data that is a mix of number and text.
gt; Ex: the field if PN
gt; The data could be:
gt; ABC123
gt; 123
gt; AB23
gt;
gt; I have formatted the column as TEXT, but if I use function isnumber(a2) for
gt; value 123, it comes back TRUE.
gt;
gt; I want 123 to be considered text; I'll be importing into Access.
gt; What's my next step?
gt;
gt; --
gt; Eva H. Linich
gt; Business Applications
gt;

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

Thx
--
Eva H. Linich
Business Applications
quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Select your single column of values
gt; lt;datagt;lt;text-to-columnsgt;
gt; [Next]
gt; [Next]
gt; Column format: Text
gt; [Finish]
gt;
gt; That should convert everything in the selected column of cells to text with
gt; a number format of text.
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;Eva at Workquot; wrote:
gt;
gt; gt; Have data that is a mix of number and text.
gt; gt; Ex: the field if PN
gt; gt; The data could be:
gt; gt; ABC123
gt; gt; 123
gt; gt; AB23
gt; gt;
gt; gt; I have formatted the column as TEXT, but if I use function isnumber(a2) for
gt; gt; value 123, it comes back TRUE.
gt; gt;
gt; gt; I want 123 to be considered text; I'll be importing into Access.
gt; gt; What's my next step?
gt; gt;
gt; gt; --
gt; gt; Eva H. Linich
gt; gt; Business Applications
gt; gt;