Excel

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

17 January 2011 Hello Friends,
Some one suggest me how to convert a number(eg. 999)into words (eg. Nine hundred and ninty nine) in Excel. Is there any function for that.

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

17 January 2011 http://support.microsoft.com/kb/213360

Please see above link.

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

17 January 2011 You can also give me your e-mail id i will mail you an Excel Add-ins for this function.

Upgrade to CAclubindia Pro. Subscribe Now!

Pankaj Jhawar

Pankaj Jhawar (Expert)
Follow

18 January 2011 Dear Sanjay ji,

Please email me the same also at jhawar.pa@magma.co.in

Pankaj Jhawar

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

18 January 2011 Check your mail.

Message likes : 1 times

Querist : Anonymous

Querist : Anonymous (Querist)

18 January 2011 Mr Sanjay, My mail id is chssmohan@gmail.com

Querist : Anonymous

Querist : Anonymous (Querist)

18 January 2011 Mr. SAnjay your suggestion was very useful. But we dont use this millin, trillion in indian currency..so suggest me an Indian Function...

Querist : Anonymous

Querist : Anonymous (Querist)

18 January 2011 And also suggest me how to save that function, do we need to save the excel workbook to save that function

Upgrade to CAclubindia Pro. Subscribe Now!

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

18 January 2011 Please check your mail. I hope your problem will be solved.

Querist : Anonymous

Querist : Anonymous (Querist)

21 January 2011 Thank You Mr. Sanjay for the file. but even though i have copied it to the Addins in MSOffice folder, it does not work. I could not know how to install that. plz guide me Sanjay

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

21 January 2011 1)1st Save the file in My Documents
2) Go to Tools and click Add-ins
3)Click browse and select from my document the file which you saved. Then Click ok.
4)Then you have 2 go 2 any cell and write =rswords(select the number u want 2 write in words)

B. Gopalkrishna Baliga

B. Gopalkrishna Baliga (Expert)
Follow

22 January 2011 aniket_baliga@yahoo.co.in
please send it to me also

Upgrade to CAclubindia Pro. Subscribe Now!

Pankaj Jhawar

Pankaj Jhawar (Expert)
Follow

22 January 2011 send to me how can i use the same in thousand and lacs

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

22 January 2011 Check your mail. The same has been mailed.