If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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 
Ads 
#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 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
how to change number to text with specific format in function  ViestaWu  Excel Worksheet Functions  4  June 26th 07 04:38 AM 
Number format using TEXT( ) function  T. Valko  Excel Worksheet Functions  6  May 1st 07 05:33 AM 
Change number (in text format) to numeric format  Pam  Excel Discussion (Misc queries)  5  October 24th 05 07:45 PM 
convert textformat number to number in excel 2000%3f  Larry  Excel Discussion (Misc queries)  1  July 29th 05 08:18 PM 
How do i change numbers in text format to number format?  Greg  New Users to Excel  1  December 14th 04 06:22 PM 