I need to be able to not round in a time sheet.
Exp:  week one total time is 40 and 1.45 ot
Sencond week is 40 and .38 OT
When you add the two OT you get 1.83, but using a format to add you get 1.84.

Greetings from Norfolk
I am trying to create a 'accounts' routine that allows the user to select
first (A) what they want to do (enter sales, monthly account etc.) then (B)
to select the month that they wish to work on.

Max, Followed directions but H8 is still only displaying Undefined...I am
stumped!
Is it possible you could have a look at the spreadsheet and tell me where
I'm going wrong?

I have created a spreadsheet that creates an ongoing average for that week.  
Each week the spreadsheet is saved and a new one is started.  Instead of a
weekly average I would like to have an ongoing 5 day average for the current
sheet and saved sheets.  How would I do this?

I have a pivot table that currently displays number of orders for each each
for two different months.  October 2005 data is in one column and October
2006 data is in the column to the right.  Then the far right column is the
grand total column.  Can you insert a calculation to ...

I protected sheet in macro with the following code but not all the column was
protected?
Worksheets("GiveGetDB").Protect Contents:=True
Any one can help?

Is there a way to have select rows print at the bottom of every sheet? Same
way as you can set it up to repeat rows at the top? I can't use the custom
footer feature as I'm printing other data there. TIA.
Mark

I have a worksheet with many drop down menus, etc, and i want people to
be able to fill it in, and then send it on ..... but you know how lazy
people are .... if they have to save it, then send it, they will gripe
about it!

I'm looking for a way to access databases (i.e., Oracle or MySQL) from
Excel.  The obvious and current solution is to do this through ODBC.  I
would prefer a more portable solution as ODBC requires the applicable
driver to be registered.  My thought would be point to a file within

I would like a Pivot table with data in all fields all rows even if the first
column is repeated. I  now have the following result:
Company         City       Country
AAA              Manchester      UK

I am trying to make a menu in exel...
and I want buttons to click on to perform the macros I have made.
So how do I make a costumize button?
Click and drag to adjust the button... things like that...

in EXCEL 2002 during the very first use of "find" one is asked what to
do with the results of the find.  Either to copy to another location in the
worksheet, or list at the bottom of the find window.  The dialog box does
not open again on subsequent uses of "find".  How does one ...

I'm just starting my work on this so please go easy on me. I have a bunch of
data in front of me that will help me generate some answers in five
different categories. I have the ability to sort the data geographically,
gender, age etc. and was wondering if anyone could recommend ...

I've a German Windows XP Pro SP2 and of course a keyboard with German
layout. Since I've installed my copy Office 2007 RTM from MSDN one key
combination no longer works, maybe others too. On German (and I guess
other European keyboard layouts too) there is the EURO-Symbol € ...

I am trying to put a serial number in a cell but it starts with a zero.
After I type in 09867453 and move to the next cell the 0 disappears.
Scott