Have a look here at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Sun, 19 Aug 2007 22:46:00 -0700, Malik Nadeem
wrote:

thank you very much for your prompt response Stephane i realy appreciate you.
could you please guide me how can i find salution of this 421 number to word
as you wrote in your following msg there are multiple example in search with
"macro", "excel", "spell" and "Number".

thanks in advance for your great support and help..

Regares
Malik Nadeem



"squenson via OfficeKB.com" wrote:

If you just need the numbers one to nine, try this:
=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine")

If you need to write 421 as four hundred and twenty-one, then you need a
macro. There are multiple examples around, try a search with "macro", "excel",
"spell" and "Number".

Stephane Quenson.


Malik Nadeem wrote:
Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1