banner_ad

Converts numbers into Word (Excel)

Excel for Finance 35655 views 14 replies

Use the sheet1 in the file where you want to convert numbers into words.


Attached File : 25 in word.xls downloaded: 10125 times
Replies (14)

Good one.. how did you do that ?? is there any macro used by you ?

no, this is simple coding. want to see the codes. download the attached file.

Good and useful file.................

Attached another file without vba code to convert amount into words.

Attached another file without vba code to convert amount into words with different formula.

WOH ---------------------- ANOTHER HELPING TIPS  FOR THE STUDENTS .

I WISH THAT "CA CLUB INDIA" WILL NEVER FORGET YOUR TIPS &  HELPING ATTEMPT .

IN MY OPINION KAUSHIK JI, & MANOJI  ARE  HELPING ALL THE STUDENTS ,

THX

Thanks Ramesh,

Attached another file without vba code to convert amount into words with different formula for Indian Lakh Format by shailesh download from https://shahshaileshs.web.officelive.com/Misc.aspx.

Kaushik

The file posted by me does not contain any VBA.

Hi,

 

Use attached formula to write a number into text.

 

For permanent installation follow these steps

 

In Excel 2003

Copy this file and

Go to Tools Menu

Click on Add-Ins

Click on Browse

And Paste this file in AddIns Folder and close it.

In Excel 2007

Got to Excel Option

Click on Add Ins

Click onManager Excel Add Ins (Go)

Click on Browse

And Paste this file in AddIns Folder and close it.

 

Below is the procedure to use this formula.

 

 

Number (Cell A1)

9999

Text Formula

=num2text(A1)

Result

Rupees Nine  Thousand Nine hundred Ninety Nine Only

 

 

Nothing to learn using your file Mr. Radheyshyam.

 

Use this unprotected file. using the same syntex.

ThanQ u very much Shyam

 

thanks for sharing

good one dudesmiley

It is very use full sir, and simple, thank you sir


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
14 May 2026
Senior Accounts Executive

Karan Gupta & Co.

New Delhi

Graduate (Any)

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

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

HiringBridge

Ahmedabad

CA

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details