Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format or function to turn a number into text.
I have a formula that spits out a simple number from 1-12, 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 1-12, 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 add-in 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 1-12, 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 1-12, 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 text-format 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 |