Use the sheet1 in the file where you want to convert numbers into words.
Attached File : 25 in word.xls downloaded: 10150 times
Use the sheet1 in the file where you want to convert numbers into words.
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
good one dude![]()
It is very use full sir, and simple, thank you sir
Your are not logged in . Please login to post replies
Click here to Login / Register
MANUJ SHARMA AND COMPANY
Noida
CA Inter
View Details
KK & Company Chartered Accountant
Pune
CA Inter
View Details
Interactive Media Pvt Ltd.
New Delhi
CA Inter
View Details
CCI
Pro
India's largest network for
finance professionals