This is a very important tool to convert no. in figures into words:
STEPS:
1) Download the attachment and save it to hard disk.
2) Open excels and goes to Tools -Add Ins
3) Go to browse and select the smb.xla file from the location where u saved
it and click OK.
USE the Formula =ntow (am
Vishal,
Thank you very much.
Regards,
Solomon
On Tue, Feb 8, 2011 at 12:19 PM, Vishal Gupta wrote:
> Hi Soloman,
> Try the sheet attached by me, it will definitly help you.
>
> Regards
> CA. Vishal Gupta
> 9463647598
>
>
>
> On Thu, Feb 3, 2011 at 4:44 PM, solomon raju wrote:
>
>> Hi All,
>>
>>
Dear Sir,
Greetings
The formula ( =ntow )mentioned in your attachment is very much useful to
persons like me.
But I am unable to use this in my working sheet. Kindly advice me in this
regard.
Thanks & Regards,
Chengalvarayan K
On 8 February 2011 13:49, Vishal Gupta wrote:
> Hi Soloman,
You're welcome,
Regards - Dave
From: rohan.j...@gmail.com
Date: Mon, 7 Feb 2011 10:49:39 +0530
Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
To: excel-macros@googlegroups.com
Hi Dave,
wonderful its a great job
Regards
ROHAN
On Sun, Feb 6, 2011 at 4:40 AM,
Hi Dave,
wonderful its a great job
Regards
ROHAN
On Sun, Feb 6, 2011 at 4:40 AM, Dave Bonallack wrote:
> You're welcome.
> Dave.
>
> > Date: Sat, 5 Feb 2011 20:31:35 +0530
> > Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
> > From: rajeshkain
You're welcome.
Dave.
> Date: Sat, 5 Feb 2011 20:31:35 +0530
> Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
> From: rajeshkainikk...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave
> Excellent work, I never thought that the convers
Hi Dave
Excellent work, I never thought that the conversion can be done by formula.
Regards
Rajesh Kainikkara
On 2/5/11, Dave Bonallack wrote:
>
> Hi Solomon,
> Have a look at the attached. Most numbers-to-text conversions are done with
> VBA, but this one is done with formulas and functions. It u
THANKS DEAR
VIKAS
On 2/4/11, rajan verma wrote:
> Hi
> I have created an attached Add-In for that..
> use Function =Inword(your_Digit) after install this..
>
> Note.. it will not show Amount after Decimal Point..
>
> Rajan
>
> On Thu, Feb 3, 2011 at 3:14 AM, solomon raju wrote:
>
>> Hi Al
Thank You Dave.
On Sat, Feb 5, 2011 at 12:41 PM, Dave Bonallack
wrote:
> Hi Solomon,
> Have a look at the attached. Most numbers-to-text conversions are done with
> VBA, but this one is done with formulas and functions. It uses a bunch of
> cells to do its workings. In your case I have put those
Hi Solomon,
Have a look at the attached. Most numbers-to-text conversions are done with
VBA, but this one is done with formulas and functions. It uses a bunch of cells
to do its workings. In your case I have put those cells in the range A50:K62.
If you need that range for something else, then y
Put into VBA moduke the "words" function below in your and use this
formula:
=UPPER("RUPEES "&words(B31) &" ONLY")
Function words(fig, Optional point = "Point") As String
Dim Digit(14) As Integer
alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six",
"Seven", "Eight", "Nine", "Ten", "Ele
Use the attached sheet..
This can be done through VBA.. I have used the code provided by Yogesh
Gupta's blog :-
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards,
Manoj Kumar
On Thu, Feb 3, 2011 at 4:44 PM, solomon raju wrote:
> Hi All,
>
> Please fi
12 matches
Mail list logo
