Hi Amresh,
Please the attached add-in.
How to Use.
Excel 2007
1. Save the attached add-in
2. Open excel sheet--click on top left iconExcel options---Add-in(on
Left hand side)---Manage (go)--- browes-- selcet the file save in step 1.
Use command =ntow()
Rgds,
Mahender bisht
On Fri, Jul
See: http://www.mrexcel.com/archive/Formulas/1559.html
On Jul 10, 4:02 am, amresh kumar amreshkushw...@gmail.com wrote:
Hi,
Please give me a solution urgent.
formula of convert numeric value of in Text
Example:
If i have 231 numeric then he convert in text value.
*IF No Any solution Please Let me know*
On Fri, Jul 10, 2009 at 3:32 PM, amresh kumar amreshkushw...@gmail.comwrote:
Hi,
Please give me a solution urgent.
formula of convert numeric value of in Text
Example:
If i have 231 numeric then he convert in text value.
231=two
Hi,
use this following link...I think it will be helpful to you.Good Luck
http://support.microsoft.com/kb/213360
On Fri, Jul 10, 2009 at 3:32 PM, amresh kumar amreshkushw...@gmail.comwrote:
Hi,
Please give me a solution urgent.
formula of convert numeric value of in Text
Hello Amresh
Kindly copy the following in a new module in VBA.
After that, use the formula =wordnum() --- (Insert cell number within
brackets)
For eg. A1=111;
use formula in B1 as =wordnum(A1) to get One Hundred and Eleven as result.
Let me know if this works.
Option Explicit
Public Numbers
Hi Amar,
I have attached an excel which contain macro that will solve ur problem.
Step 1 - Open an excel workbook, then Go to Tool option/ Macro/ click on
security. In security click on Medium redio button press ok.
Step 2 - Save attached file at ur computer.
Step 3 - Click on attached file