banner_ad

convert number into word

Excel 6047 views 5 replies

can anybody tell me the procedure of converting number into words(indian format)  in excel 2007

for example 50,000 to fifty thousand

Replies (5)

Dear Vipin Gupta,

Their is No Any Formula For Converting Figure into Words in MS Excel.......... But By Using VB We Can Convert it.......

 

So I Here Uploaded a File In Which U Can Just Put Figure & by Writting the below Formula..

=spellrupee(cell address)

U Can Convert..................

 

Regards,

Ayush Agrawal

ayushagrawal @ rediffmail.com

 

 

.Here is File.................

If you want formula to convert number into indian rupees in word without any vba code download attached excel workbook. If you want addins to convert # to Rupees in words download "Indian Rupees" by shailesh from below site. With this addins you can also format number as indian decimal system e.g. 91234567.89 to 91,23,457.89

 
https://shahshaileshs.web.officelive.com/Addins.aspx
 
 
Kaushik

Use this file. No VBA.

there any formula in which we can cmbine the word with amount in that way if we change any of no or word the amount will also change


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
08 May 2026
CHARTERED ACCOUNTANT

SHAH LADHA AND ASSOCIATE

Ahmedabad

CA

View Details
Company
04 May 2026
Articleship

S.K Gairola & CO

New Delhi

B.Com

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
14 May 2026
Senior Accounts Executive

Karan Gupta & Co.

New Delhi

Graduate (Any)

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details