Home 
Search 
Today's Posts 
#1




Format or function to turn a number into text.
I have a formula that spits out a simple number from 112, I need that number
to be expressed as a word (one, two, etc.) instead of the actual number. I assume there is either a format or a function that I can use that will convert the number for me, but I haven't been able to figure it out. Any suggestions? Thanks 
#2




Format or function to turn a number into text.
Look he
http://xldynamic.com/source/xld.xlFAQ0004.html  Kind regards, Niek Otten Microsoft MVP  Excel "Chad" wrote in message ... I have a formula that spits out a simple number from 112, I need that number  to be expressed as a word (one, two, etc.) instead of the actual number. I  assume there is either a format or a function that I can use that will  convert the number for me, but I haven't been able to figure it out. Any  suggestions?   Thanks 
#3




Format or function to turn a number into text.
Nothing built in
http://preview.tinyurl.com/2az4hr http://groups.google.co.uk/group/mic....programming/b...) or use an addin http://xcell05.free.fr/ download and install Morefunc  Regards, Peo Sjoblom "Chad" wrote in message ... I have a formula that spits out a simple number from 112, I need that number to be expressed as a word (one, two, etc.) instead of the actual number. I assume there is either a format or a function that I can use that will convert the number for me, but I haven't been able to figure it out. Any suggestions? Thanks 
#4




Format or function to turn a number into text.
As you have a specific (small) range of numbers, you could do it like
this: =IF(AND(A1=0,A1<=12),CHOOSE(A1,"One","Two","Three ","Four","Five","Six","Seven","Eight","Nine","Ten" ,"Eleven","Twelve"),"") Checks that your number in A1 is valid, then returns the word  put it in B1. Hope this helps. Pete On Oct 5, 8:55 pm, Chad wrote: I have a formula that spits out a simple number from 112, I need that number to be expressed as a word (one, two, etc.) instead of the actual number. I assume there is either a format or a function that I can use that will convert the number for me, but I haven't been able to figure it out. Any suggestions? Thanks 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
how to change number to text with specific format in function  Excel Worksheet Functions  
Number format using TEXT( ) function  Excel Worksheet Functions  
Change number (in text format) to numeric format  Excel Discussion (Misc queries)  
convert textformat number to number in excel 2000%3f  Excel Discussion (Misc queries)  
How do i change numbers in text format to number format?  New Users to Excel 