Numbers SHOULD BE text

[Guest]

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?

 

[mrice]

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

 

[Guest]

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

 

[Guest]

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

Thx
--
Eva H. Linich
Business Applications

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

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?