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