Converting figures into words In Excel

M

Mahesh.P.P

Hi,

Could anybody help me. Just need to know how to convert
figures into words automatically. ie, when I enter a
figure , I need it to be displayed in words. To be more
precise, when I enter a cheque amount in a cell, I need
the amount to be converted into words and displayed in the
next cell in Excel. Please help

Regards
Mahesh
 
K

Kevin McCartney

You'll find a function on this web page, you can change
the wording to suit your locale requirements.

http://www.planet-source-
code.com/vb/scripts/ShowCodeAsText.asp?
txtCodeId=520&lngWId=-1

regards
KM
 
Top