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,
I've a quick question on an event Private Sub Worksheet_Calculate().
I got Private Sub Worksheet_Calculate() running on Sheet1 which does
few calculations and calls a macro.
Is it possible I can create another event in same worksheet Private
Sub Worksheet_Calculate() which would do anot
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
Maybe u need a combination of Data Validation and VLookup Function. Please
attach a sheet with data so that solutions can be provided.
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati :
fyi
-- Forwarded message --
From: amresh kumar
Date: Fri, Jul 10, 2009 at 3:32 PM
Subject: Please give me a solution urgent.
To: excel-macros@googlegroups.com
Hi,
Please give me a solution urgent.
formula of convert numeric value of in Text
Example:
Hi,
I'm new one to this group.
I'm facing problem in excel for Date Formating.When I'm selecting
Entire column of Date, after selecting to Date option in Format, all
dates are not coming in same format.
Can anybody help me out in this ?
Excel sheet is attached for your reference.
Thanks in A
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
hi
'Ctrl+Shift+Enter' is used for is just the combination chosen by
Microsoft to distinguish array formulas from the regular
formulas ...and pressing this CSE combination is necessary (else it
gives #value error) for array based formulas and it automatically
insets those curly braces... anyways,
*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,
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 one
1000=thousand
1020=one thousand twenty
Regards
AK
--~--~-~--~~~---~--~~
-
Dear Anand,
You can find all the tips at www.exceldailytip.blogspot.com. I will
update this blog soon with the tips submitted in the competition.
Hope it helps
Best regards,
Ayush Jain
On Jul 10, 1:44 pm, anandydr wrote:
> Dear Ayush,
>
> Could you please provide the links to where th
Dear Ayush,
Could you please provide the links to where these tips can be found?
Anand Kumar
09718516200
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VB
ashish
can u please mail your excel sheet as a sample so that the code can be
written around that
thanks
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Thu, Jul 9, 2009 at 11:44 PM, Ashish Pradhan wrote:
> Hi
>
> Been racking my brains fo
Thanks Ayush.
Indeed Singh is king
I have contributed very less to this group but learned a lot.
I will continue searching new tips and share with group.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
16 matches
Mail list logo
