1  .3125
2  .3571
3  .4167
4  .4348

I might have posted my original question in the wrong area initially. The
answer i recieved from the General Excel forum was way beyond my ken.
Please see the post below and the answer I recieved. If someone could
explain how the answer works or send an alternative answer that ...

When I try to customize my QAT, I get a green ball icon for each command
that doesn't have an icon by it in the customize screen.  So I currently have
5 or 6 green balls on my QAT and it sort of defeats the purpose of having a
"quick" access toolbar if you have to hover and wait ...

Please bear with me as I am new and dumber than a pocket full of rocks when
it comes to this kinda of stuff, but learning. This is the Scenario: The
company I work for also has M/S office I created a work sheet at work & home
named DOGS. I do most of my work at home... can I ...

Trying to find a way to find "good" retail numbers based on cost of
goods.
Right now if I want a 40% margin on cost I use the following
=ROUND(A1/((100-$40)*0.01),0)+0.95

I've been fiddling about scratching my head and I just can't get what I want
so hopefully someone here can help.
I have one column with timestamps starting from 0:00:00 going up to about
2:10:00 (in theory at least as only a few times are filled), one column of

I am using Excel 2007. I want to keep a group of cells from being
edited/sorted and still use the data from those cells. Is this possible? If
so how do I do it.

I've been fiddling about scratching my head and I just can't get what I want
so hopefully someone here can help.
The data I have are 1 column with timestamps, 1 with force type, 1 with
force strength.

I have a workbook with 50 sheets.
On each sheet I put the same Custom Header and Custom Footer.
The Header/Footer is just plain text, (just 50 characters in total.)
After putting the Header/Footer on the 50 sheets the file size has

I have this:
1  
   4
3  

Hi - imagine that I have 2 worksheets in my workbook.
Worksheet 'MASTER'
   5 columns x 4 rows
   Column 1 = KEY and Columns 2 - 5 = numbers (data)

I have a pivot table based on customer name (vertially, rows) and product
(across, columns).  In each record is the date.
How can I base my pivot tables selection on a dynamic date range.  
Specifically to display records only as far back as 6 months.  Lets say

I am useing WinXP with Office 2007 excel.  I can not get <hex
number>+<ALT>+<X> to work for Unicode hex numbers.  I can insert useing the
character map, but typing long strings of Math symbols is so slow this way.
Every time I hit the <ALT> key, the ribbon numbering system pops up ...

Excel 2007
Win XP latest SP
McAfee Antivirus recently installed causing all kinds of other problems
I opened a Worksheet this morning and most of my conditional formatting was

In Colum A I have prices.. In column B I'd like to show the price in column
A minus a 20% discount.. I can't figure it out..