Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERTING NUMBERS TO TEXT
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERTING NUMBERS TO TEXT
See:
http://support.microsoft.com/default...EN-US;Q213360& -- Gary''s Student - gsnu200812 "Briggs" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERTING NUMBERS TO TEXT
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERTING NUMBERS TO TEXT
Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html ....then use this formula =NBTEXT(A1) "Briggs" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERTING NUMBERS TO TEXT
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERTING NUMBERS TO TEXT
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! -- Briggs "ShaneDevenshire" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting text to numbers | Excel Worksheet Functions | |||
Converting text to numbers | Excel Worksheet Functions | |||
converting numbers to text | New Users to Excel | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) |