Hi,
this is simple way to do.
Go to XLstartup folder and delete excel 2007 icon.
So default excel 2003 opens.
i m travelling . so cannot provide the exact path where xlstartup exist.
Try this
if not possible one more solution is there..
On 1/29/12, Dilip Pandey wrote:
> Hi Sajid,
>
> I h
Hi Avinash,
Not entirely getting your point.
Please confirm if you need following < which I can understand per your post> :)
1) Following results as per Date in first field < this you have
already attached>
DateTotal Product Actual PriceTotal Number Of ProductsGrand
Total She
Hi Sajid,
I had the similar issue and corrected that later... since I run Office
2010 and can't test this out but sill remember following two option
which I had tried during my encounter :)
Two tryouts :-
1) Right click an excel file (preferable xlsx) -> open with -> choose
"Excel 2003" as the de
Hi Prabhu,
If you have the amount in number format, simply divide it by 10.
If you have the amount in text i.e., Rs.924104600.90, use following
formula:-
="Rs."&TEXT(VALUE(MID(a1,4,50))/10,"0,000")
You can play around with format "0,000" which is present at the right
end of the formula.
Dear Experts,
I am using windows 7 platform and installed Excel 2003 & 2007
(both). When i click at any excel file it open by default in excel 2007. I want
default should be excel 2003.
Please give me suggesstion. I have done from view menu and programme default in
2003 but
Hi,
In Excel I needs to convert numbers in to indian format and the value
should divided by lakhs and display in Lakhs.
Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian
format)
Plz help.
Regards,
Prabhu
--
FORUM RULES (986+ members already BANNED for violation)
1) Use con
hi Ansari,
I am bit new to vba coding as this pivot source data is within sheet as per
attached sheet .
*my query is *
if i have data in different sheet please advise.
can you please help to provide this below listed steps code
1) to copy particular sheet from one existing workbook to
Just to be clear, in the general case, you can add times to date/times. In
the example spreadsheet the "End Date" column sometimes already included the
time, even though it was hidden by the cell format -- thus the inconsistent
results. Sam's solution is effective at removing redundant times from
Hey Amit,
>
>look for SUMPRODUCT formula information and you will get your answer.
>
>From: Amit Desai (MERU)
>Sent: Saturday, January 28, 2012 2:43 AM
>To: excel-macros@googlegroups.com
>Subject: RE: $$Excel-Macros$$ Excel - Array Help
> Thanks
Noorain,
>
>I
have just seen your email...
>
You don't compare RESULT of two, you check if the count of the number of
times your equation is satisfying the criteria is greater than 1 or not. So
if you equate $A$2:$A6=A6 you will get some TRUE and some FALSE. Similary
for column B also you'll get some TRUE and FALSE. The multiplication of
bool
Posting the code might help!
Sam
On Sat, Jan 28, 2012 at 2:09 AM, IF wrote:
> I am trying to add an item to a specific collection within a dictionary.
> I am not sure how to do this. Any ideas? Thank you.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, ac
I am trying to add an item to a specific collection within a dictionary. I
am not sure how to do this. Any ideas? Thank you.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pr
Did you copy down the formula?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Saturday, January 28, 2012 2:43 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Excel - Array Help
Thanks Noorain,
I have just seen your email...
I unders
You cannot add time to a date that already has time. The solution has to
take out the date value and time value separately. Otherwise, it will give
inconsistent results.
Here's how the calculation should be. Also, formatting it to [h]:mm:ss will
give an exact idea of the duration.
=ROUNDDOWN(G6,0
Here's a simple example where you can SETFOCUS on a user form control
Regards,
Sam Mathai Chacko
On Sat, Jan 28, 2012 at 5:46 PM, Shankar Bheema wrote:
> Hai Asa.
>
> May I have one example pls. Because I tried but I did not get.
>
> regards
> shankar sb
>
>
> On Sat, Jan 28, 2012 at 1:30 PM, A
Venkat,
You are digressing from the question, although explaining what absolute and
relative reference is good for common understanding. The question in
particular, however, is regarding relative reference in vb developer tab.
Vijay, the Relative Reference button is just a way to tell the VBA wh
Dear Yasir
Please find the solution in the attached file.
On Sat, Jan 28, 2012 at 10:12 AM, yasir_shahjee wrote:
> Respected Masters,
>
> Kindly check attached sheet. i need Time calculate in Hours. hopefully its
> really easier for Masters.
>
>
> thanks
>
> --
> Yasir Waheed
> Factory Manager
Hai Asa.
May I have one example pls. Because I tried but I did not get.
regards
shankar sb
On Sat, Jan 28, 2012 at 1:30 PM, Asa Rossoff wrote:
> Also, regular form controls support the Enter event which is very
> similar. It fires when the control gets focus from another control on the
> for
Hi Vijay,
Look Below about relative refrence..
*What are the types of references?*1. Absolute Column/Absolute Rowe.g.
$A$1means
Whether you use auto-fill across column or across row, the reference won't
be changed.
2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across
column,
Thanks Noorain,
I have just seen your email...
I understand the formula...only part i am not getting is... this pat
($A$2:$A2=A2)*($B$2:$B2=B2))>1...how the result of 2 comparison can be greater
than 1?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NO
Also, regular form controls support the Enter event which is very similar.
It fires when the control gets focus from another control on the form. Form
controls also have an Exit event, which is like LostFocus but only among the
form's controls (when the form gets/loses focus these events are not f
21 matches
Mail list logo
