View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
 
Posts: 78
Default how to get serial number in word? like 1=one, 2=two

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