Trying to create multple rows with each showing
[14.3 hrs @ $185/hr]  (each row different hours and $rate)
It's necessary for us to have the brackets showing, but a cell with [14.3 in
it is not recognized as a number - same thing applies to the $185/hr

Hi - I want to be able to take a mailing list and get a count of the suburbs
with the same names - providing me with suburb distribution of that mailing
list.
I have attempted to do this by utilising the COUNTIF function and setting

I have just upgraded to office 2007. Looks great but..if I hide or unhide a
column in one sheet it affects columns in another sheet also?
And I cant print or pdf just one sheet. I get all the pages even when only
one is selected...

I need to add the dollar amount in C2-C80 if the word in d2-d80 matches.
I need the total in g
sum of c2-c80 if d2-d80=word (Total in g2-g13)

I already know how to sum a *range* of cells.
Click, drag, release, and then click on the Sigma
icon.
That sums up a range of cells.

I've downloaded a csv file from bank. The date needs to be in MM/DD/YYYY. I
type in in as text 01/01/2007 but when I save it it reverts back to date
format.

I just purchased a 20" widescreen monitor. My spreadsheets now appear to be
stretched across a wider screen as opposed to seeing more columns than
previously viewed on a standard 19" monitor. Is there a setting to view more
columns on the screen instead of just stretching the ...

I'm trying to convert 12 digit strings to individually unique 4 digit strings
for product coding. Any ideas?

=COUNTIF('Feb ''07'!G2:G4999, "<=:00:30")-COUNTIF('Feb ''07'!F2:F4999,
"System")
That's the beginning formula that I'm working with.  Now, this is to
assist in tracking calls that come in that are less than or equal to

HI, I have a spreadsheet with formulas. When I go to Tools Options, Formula
Auding the Trace Precedent Bars are grayed out. Why?
When I go to tools options view and click on view all, it shows up, BUT IT
PLACES A BOX WITH A SCROLLING BAR ON IT that I cannot get rid of.

Anyone know how to convert a list of number (A1:A78) to a 6 column grid so
the numbers go down 6 rows and down the next 6 rows etc until you reach the
end of the list/col?
I'd like to do it in VBA but I'm not clever enough!

I am trying be able to enter actual hours worked in a day and have it
calculate what is regular time and overtime with RT being 7:00am - 3:30pm
(1/2hr lunch included) M-F anytime before or after is OT.. PLEASE HELP!!!!
THANK YOU

Excel2003 ... I have 12 TabSheets (1 for each month ... Jan, Feb, Mar etc)
In each TabSheet I would like a cell result returned (format = mm/dd/yy)
based on the following:
If 1st day of ( Jan ) is a:

I have a list of Names and dates in col A and start and end times in col b
and c and Names in col Q, I have worked out this
"=SUM(IF($A$1:$A$13562=$Q$4,$C$1:$C$13562-$B$1:$B$13562))" to find out how
long we have spent at a given name down the whole of col a, I would like to

Can you pls. give me the formula to convert pounds to net tons ( 2000 lbs.)
in excel spreadsheets