CardText

M

Mani K

How do I convert the firgures (numners) in to words in Excel? In Word we
have CardText\*
 
G

gandhi318

Dear Mani

Did u try the link suggested by mr. bpeltzer
I changed Dollars to Rupees and Cents to Paise by Find and Replace i
the code of Microsoft from the above link and it is workin
excellently

In 1980's i used different functions on a worksheet by combination an
got the figures converted into words in Lotus which i continue to us
in Excel in all versions now in xp
Now i can even get that with use of very less functions on which i a
now working. But if u can do with the above code copying from Microsof
as I did that will do. If u want mine which can be understood ver
easily as they are only functions u may call back t
[email protected]

I game my suggestion to your other thread on "function to convert th
number to read it as Text" and no more maths function after convertio
(reading) it as text. That was not conversion of figures into word
discussed above. Please note the change

Regards,
Gandh
 
M

Mani K

Thanks a lot. shall feel more happy if you could additional details
(Examples!).
Wish U a very happy new year 2006
 
Top