Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert numbers (ex. "4") to text (ex. "four")
I need to convert some numbers into text. For example, I have a cell with a
number "4", and I need to get a cell with a the text "four". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert numbers (ex. "4") to text (ex. "four")
Look he
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Help!" wrote in message ... |I need to convert some numbers into text. For example, I have a cell with a | number "4", and I need to get a cell with a the text "four". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert numbers (ex. "4") to text (ex. "four")
If A1 has a number like 1 or 2 or 3 or 4 then in another cell:
=CHOOSE(A1,"one","two","three","four") -- Gary''s Student - gsnu200765 "Help!" wrote: I need to convert some numbers into text. For example, I have a cell with a number "4", and I need to get a cell with a the text "four". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert numbers (ex. "4") to text (ex. "four")
I need to convert some numbers into text. For example, I have a cell with a number "4", and I need to get a cell with a the text "four". I believe Excel may have a lookup table capability, or you could use an array. but if the range is large with values into the hundreds this may not be an option. I haven't seen a function that converts 1227 into one thousand two hundred and twenty seven, but Excel has a vast collection of obscure functions. Problem with large numbers is that there is more than one way to express them, 1227 to some is twelve hundred and twenty seven. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert numbers (ex. "4") to text (ex. "four")
On Mon, 21 Jan 2008 12:13:01 -0800, Help!
wrote: I need to convert some numbers into text. For example, I have a cell with a number "4", and I need to get a cell with a the text "four". Download and install Longre's free morefunc.xll add-in. Then use the NBTEXT function. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |