How to convert numbers to figures

[Shekhar Attri]

I have a column which contains some numbers like, 200, 2450, 45200, etc. I
want to write these no. into words like Two Hundred, Two Thousand Four
Hundred and Fifty.

 

[Bob Phillips]

See

http://www.xldynamic.com/source/xld.xlFAQ0004.html
Excel FAQs - Convert Numbers To Text

--

HTH

RP
(remove nothere from the email address if mailing direct)