Dear Delin,
Please see attached sheet with Excel and VBA solution both.
On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS wrote:
>
> HI friends...
>
> A small query in excel is there any way to convert numbers in to words
> eg :-
> 1202 = One Thousand two hundred and Two
>
> for more details fi
Hi,
Kindly use this function code .
"Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim DecimalPlace As Long, Count As Long
Dim myLakhs, myCrores
ReDim Place(9) As String
Place(2) = " Thousand ": Place(3) = " Million "
Place(4) =
HI friends...
A small query in excel is there any way to convert numbers in to words
eg :-
1202 = One Thousand two hundred and Two
for more details find the attached file
thanking you all in advance
regards
Delin.F
--
Join official Facebook page of this forum @
https://www.facebo
*Dear Sanjay*
*Also use a meaningful subject's to your mails...*
*Regards*
*Pravin.
*
-- Forwarded message --
From: अनिल नारायण गवली
Date: Mon, Dec 17, 2012 at 10:43 AM
Subject: Re: $$Excel-Macros$$ Help Please
To: excel-macros@googlegroups.com
Dear Sanjay,
U cannot give same n
Congrats to my friends.
Regards,
Gawli Anil
On Mon, Dec 17, 2012 at 7:37 AM, SHREYAS GUPTA wrote:
> Sir,
> If the above link is not working please use this link-
>
>
> http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx
>
> Regards
> Shreyas Gupta
>
>
>
>
> On Mo
Dear Sanjay,
U cannot give same name to two sheets. And while inserting the default name
will be "Sheet and the number ".
II'm guessing that u want the name while inserting a blank sheet . a name
which is defined by U and not the excel program.
If i'm guessing right then logic is
*Sub AddWorkshe
Each sheet in a workbook has to have a different name from any other sheet
in the same workbook.
Subject to that constraint you can change the name of the inserted sheet
after you have created it.
Can you give more detail of what you are doing. Ie how you are inserting
the sheet, what name you want
Hi Sanjay,
This is not possible in excel that two worksheets have same name in a same
workbook.
Regards
Prince.
On Monday, December 17, 2012 9:29:13 AM UTC+5:30, Sanjay Kumar Maurya wrote:
>
> Dear All,
>
> I'm inserting new sheet in a workbook but all sheet have a different name
> like shee
Sir,
If the above link is not working please use this link-
http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx
Regards
Shreyas Gupta
On Mon, Dec 17, 2012 at 6:28 AM, SHREYAS GUPTA wrote:
> Sir,
> I saw the calendar made by Mr. Debaranjan. The calendar is not
Sir,
I saw the calendar made by Mr. Debaranjan. The calendar is not made by Mr
Debarajan himself it is downloaded from
http://www.vertex42.com/Files/download/themed.php?file=yearly_event_calendar.xlsx
and
only modified by him. You can easily see the properties of the excel
calendar made by Mr.
Are you using Excel 2007 or Excel 2010?
I'm using Excel2010.
When I first open your files, I see the "#NUM!" values.
But when I click the "edit" button, the errors go away and the values appear.
Paul
-
“Do all the good you can,
By all the means you can,
hi be tran van
share your file with me.
regards
prince
On Saturday, December 15, 2012 9:58:14 PM UTC+5:30, bé trần văn wrote:
>
> Welcome Prince.
>
> File TIEN TIM 3 if I format the Number type, the error happened 1004
> (Unable to get the match property of the WorksheetFunction class), in
> c
12 matches
Mail list logo