View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default CONVERTING NUMBERS TO TEXT

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.

--
Thanks,
Shane Devenshire


"Briggs" wrote:

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!
--
Briggs


"Peo Sjoblom" wrote:

Can you give an example what you want to do?

--


Regards,


Peo Sjoblom

"Briggs" wrote in message
...
How can I convert numbers to text? I get how to convert text to numbers,
but
can't seem to convert numbers to text.
--
Briggs