Can digits convert into word automatically ?

Hi there,

You'll need to implement some VBA to do this. If you search around on Google there's a few links that might help. Here's a couple to get you started:

http://www.meadinkent.co.uk/xlnumberstext.htm
http://www.ozgrid.com/VBA/ValueToWords.htm

HTH,

SamuelT

Hi Premmadaan,

Check out the attached file. Just select the numbers you wish to convert to words and press the button. It is customized with 'Rupees' and 'Paise' as currency .

--Karan--

Hi Premmadaan,

Did you enable macros?

If you are using Excel 2003, you need to turn the security to medium by selecting Tools >> Macros >> Security >> Medium and then restart Excel and choose to 'Enable Macros'.

It would surely work.

--Karan--

Originally Posted by Premmadaan

Thanks a lot
Now its working..

It willl really help full to me..

Thanks again

I am new user to this,

I Have Checked above mentioned .xls file, it is very good, it is shown in billion format, is there any formulae for convert numbers to words(Indian rupees)

For Example,

111,11,11,111.10 is "One hundread crores eleven lakhs eleven thousand one hundread eleven rupees and ten piasa only"



Thanking you all


Regards
Ashokchary

Refer this file. This gives the output in lakhs & crores.

Type '=spellindiantotal(any number)' to get the desired output. Make sure you enable macros.

--Karan--

Originally Posted by karan

Refer this file. This gives the output in lakhs & crores.

Type '=spellindiantotal(any number)' to get the desired output. Make sure you enable macros.

--Karan--

Thanks Karan,

Can you help to design a Macro for converting 1,719,180,288.00 to One Hundred Seventy One Crore Ninety One Lakh Eighty Thousand Two Hundred Eighty Eight.

I'm using Excel 2007

Regards

Originally Posted by karan

Refer this file. This gives the output in lakhs & crores.

Type '=spellindiantotal(any number)' to get the desired output. Make sure you enable macros.

--Karan--

good work guy.

Is there any formula to conver digits convert into word ?