Use the sheet1 in the file where you want to convert numbers into words.
Converts numbers into Word (Excel)
Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
11 May 2010
14 Replies
CA CS CIMA Prakash Somani
(Landmark Group)
(23502 Points)
Replied 11 May 2010
Good one.. how did you do that ?? is there any macro used by you ?
Manoj Garg
(Support on Tally Excel Password Recovery etc.)
(1987 Points)
Replied 11 May 2010
no, this is simple coding. want to see the codes. download the attached file.
Attached File : 22 in word unprotected .xls downloaded: 5406 times
CMA.Baskar.V
(Cost Accountant)
(400 Points)
Replied 12 May 2010
Good and useful file.................
Kaushik
(Professional)
(549 Points)
Replied 13 May 2010
Attached another file without vba code to convert amount into words.
Attached File : 16 numstowords no vba.xls downloaded: 3084 times
Kaushik
(Professional)
(549 Points)
Replied 13 May 2010
Attached another file without vba code to convert amount into words with different formula.
Attached File : 32 xld spellnumber.xls downloaded: 2789 times
RAMESH KUMAR VERMA
( CS PURSUING )
(43853 Points)
Replied 13 May 2010
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
Kaushik
(Professional)
(549 Points)
Replied 13 May 2010
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
Attached File : 9 indianspellnoformula.zip downloaded: 1998 times
Manoj Garg
(Support on Tally Excel Password Recovery etc.)
(1987 Points)
Replied 13 May 2010
The file posted by me does not contain any VBA.
Attached File : 50 in word unprotected .xls downloaded: 1844 times
Radhe shyam
(Officer Finance at JSW Energy Ltd)
(50 Points)
Replied 27 May 2010
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 |
|
|
Attached File : 6 num2text.xla downloaded: 5703 times
P K
(Excel Developer)
(130 Points)
Replied 27 May 2010
Nothing to learn using your file Mr. Radheyshyam.
Use this unprotected file. using the same syntex.
Attached File : 4 amount to word.xls downloaded: 893 times
G CHANDRA SEKHAR
(Senior Accounts Officer)
(32 Points)
Replied 09 February 2022
It is very use full sir, and simple, thank you sir
Recent Topics
- Profit or Loss on Sale of Assets Accounting treatm
- Clarification on RCM on Rent Payment for QRMP Deal
- Reclaimed itc in gstr9
- Gamification in Accounting Software: Boosting Enga
- I want to knw Hsn code and gst rate of resin produ
- Schedule FA clarification
- Income tax on freelance income from crypto
- ITC temporary reversal and reclaim
- Query on Transactions
- Two GSTN under different PAN in same address
Related Threads
CAclubindia
