Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Format or function to turn a number into text.
5 views
Skip to first unread message
Chad
Oct 5, 2007, 3:55:00 PM10/5/07
to
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?
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
Niek Otten
Oct 5, 2007, 4:29:31 PM10/5/07
to
Look here:
http://xldynamic.com/source/xld.xlFAQ0004.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Chad" <Ch...@discussions.microsoft.com> wrote in message news:9DB17C62-055E-4917...@microsoft.com...
Peo Sjoblom
Oct 5, 2007, 4:36:41 PM10/5/07
to
Nothing built in
http://preview.tinyurl.com/2az4hr
http://groups.google.co.uk/group/microsoft.public.excel.programming/b...)
or use an add-in
download and install Morefunc
--
Regards,
Peo Sjoblom
"Chad" <Ch...@discussions.microsoft.com> wrote in message
news:9DB17C62-055E-4917...@microsoft.com...
Pete_UK
Oct 5, 2007, 7:30:27 PM10/5/07
to
As you have a specific (small) range of numbers, you could do it like
this:
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
0 new messages