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 w
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 As
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 wrote:
> Hi,
>
> Please give me a solution urgent.
>
> formula of convert numeric value of in Text
>
> Example:
>
> If
*IF No Any solution Please Let me know*
On Fri, Jul 10, 2009 at 3:32 PM, amresh kumar 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.
>
> 231=two hundred thirty
See: http://www.mrexcel.com/archive/Formulas/1559.html
On Jul 10, 4:02 am, amresh kumar 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.
>
> 231=two hundred thir
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 icon>Excel 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,
