CONVERTING NUMBERS TO TEXT

[Briggs]

How can I convert numbers to text? I get how to convert text to numbers, but
can't seem to convert numbers to text.

 

[Gary''s Student]

See:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&

 

[Peo Sjoblom]

Can you give an example what you want to do?

--


Regards,


Peo Sjoblom

 

[Teethless mama]

Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/3000-2077_4-10423159.html

....then use this formula

=NBTEXT(A1)

 

[Briggs]

We have a file with ID numbers that I believe may have a name attached to
each ID number that we can't see. I thought I could try and convert, but the
only option I get is to convert text to number-----but it's already a number.
Hope this clears it up. Thanks for your reply!

 

[ShaneDevenshire]

Good question Peo!

None of the answers supplied wil do what you want, they all thought you
wanted to convert 12 to Twelve.

If you can't see it, at least in this case, it's not there! You need to go
back to the original source data. Or maybe there is a list somewhere of
whose name matches which ID, in which case you can use VLOOKUP to match a
number with the corresponding name - once you have a complete lookup table.

 

[Briggs]

Shane,

That's exactly what I needed to know; whether it was possible to retrieve
without being the creator of the spreadsheet. I wish they would've hidden
the name behind the ID number, but it's good to know that it just ain't there.

Thanks, again, for your help!