Hi,
By recording a Macro and using the text import wizard i have obtained the
following code at the end of this post.
However, this always places the data in the active worksheet, and i would

Is there anyway possible to change the default layout of an excel spreadheet
in the way of how it shows a negative value, eg as the minute when you choose
the cell to be a currency it shows up as - £800 in red, but id like it to
change it to (£800) instead.

I am trying to count a colomn I3:I197 and only need to count the cells that
contain the text OG. I have tried CountIf but I am getting nowhere. Can
anyone help please?
Thanks

Dear Sir,
I use =MID(A1,2,6) to convert the original reference numbers to six digit
reference in column B.
After that I use VLOOKUP formula in cells B10 to B15 to lookup for the

After upgrading to 2007 I can no longer use the short cut Ctrl and the + on
the keyboard by the numbers I have to use the + above the letters. Is there a
setting I have to make before I can use the + out to the left next to the
numers on the keyboard. It's to make a new row. It ...

I have created a table and applied a table style with alternating banded
rows. When I convert it to a range in order to use the subtotals feature, the
banding does not alternate anymore. In addition, when I convert the range
back to a table and try to reaply the banded rows ...

Folks - Usually I can figure out the solution to problems by fiddling around
and searching but this one has my stymied.
I use Office 97, and in the last few weeks, in Word and Excel, whenever I
open a file and start working on it, the "Save As" dialog box comes up (by

Hi people!
is it possible to set up excel so that when you choose one value from one
drop down menu in column A, you get to have a certain set of drop down values
in column B assigned to that same value from Column A.

I am wanting to multiply an order by a fixed cost (0.055c) up to an
order quantity of 13,000. Thereafter, for every FULL 500 units over
the 13,000 the cost will increase by 0.001c.
Examples:

Hi guys, Looking for a way to extract the month from the following date....
01/03/2007 00:00
I need the formula to pull out the month ( 03 ) and give it it's name ,, as
in March for 03 ,, can this be done ?

A        B         C                              D                    
    E
1     25      30       25*30                       100*100              
10*10  

I have a table called hinnakiri which has a lot of rows and 3 columns with
headers (Material, Price, Other Price)
And I have a column where I can select material name from a DataValidation
drop-down listbox.. I need to update the cell next to it with a price from

I am using the following formula to compare a range of cells for dates and to
return a high and low date in one cell.
=TEXT(MIN($B9:$IV9),"mm/dd/yy")&" to "&TEXT(MAX($B9:$IV9),"mm/dd/yy")
My question is this:  what do I use in place of mm/dd/yy formatting if I

Client has a prob where they have some staff using 2003 excel viewer and if
they
have a workbook open in veiwer, then the accounts staff can't save their
changes in the same workbook in their Excel 2002 program without having to go

I know that Tracying the dependent cell, i should use Ctrl + "[" .
Is there shortcut key that I can go back?