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
THANKS DEAR
VIKAS
On 2/4/11, rajan verma rajanverma1...@gmail.com 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
Thanks for your suggestion. Have given up and have now implemented
code to perfrom validation myself but really appreciate your response.
My first time using the forum and impressed with the support out
there , so thank you.
On Jan 31, 11:34 pm, clivey cdr...@gmail.com wrote:
mmm...this rings a
Hi Dave
Excellent work, I never thought that the conversion can be done by formula.
Regards
Rajesh Kainikkara
On 2/5/11, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Solomon,
Have a look at the attached. Most numbers-to-text conversions are done with
VBA, but this one is done with
I am trying to amend a VBA macro that I created some time ago using
WinXP and Excel 2003.
This macro sends a temp worksheet via outlook to the names listed in
the sendMail.array.
What I am now trying to do is create a dynamic named range somewhere
in the workbook that can be added to or email
Hi All,
I am new to this group. I did not know if I should create a new
Discussion or enter in one with the same kind of subject in under
discussion, thought I did tried the second.
I am trying to know if is it possible to create a VBA UDF that will
be multi thread in a multi core cpu, or
I have created a complex spreadsheet that extracts certain worksheets
and modules and creates another workbook which is subsequently emailed
using Outlook to a list of individuals. It is not a complete copy of
the original workbook as there is information which must not be sent
out.
However I
Dear Admin,
Can you please add me for the excelmacros mails, my email address is
gau...@omanairports.com.
Thanks regards,
Gaurav Bansal
Muscat, Oman
--
--
Some important links for excel users:
1. Follow us on
suppose your email ids are sdtored in sheet 1 and column 1
it will concatenate all the email ids
For i = 1 To Sheets(1).Range(a1).End(xlDown).Row
all = all Trim(Sheets(1).Cells(i, 1).Value) ;
Next i
to_mail = Left(all, Len(all) - 1)
MsgBox to_mail
Set olApp = New Outlook.Application
Set
I have created a complex spreadsheet...
..
Can anyone point me in the right direction
Right Direction : Don't Create complex worksheet, keep life simple :-)
Regards, Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
-Original Message-
From:
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 conversion can be done by formula.
Regards
Hi friends,
I wanna know if we can pass the variables without initializing them to any
other
function and get their values from that called function please find the below
example. which is similar to that of i have seen.
dim workingday as some data type
Sub calling ()
if not
I jsut wish keeping it simple was a option open to me
The reason it is a complex spreadsheet is because it has to be
automated for absolute morons to use on a daily basis - ie not being
able to put information in unless validated and in the correct format,
etc etc
Brian
On Feb 5, 4:43 pm, Anil
13 matches
Mail list logo