how do i move the grand total row to the beginning of my pivt tble

I have a range formatted as 00000000.  When I type 354 in a cell, I get
00000354 as expected.  No problem.
When I use the Analysis Pak function = DEC2BIN(1), I get 1 instead of
the desired 00000001.   A different function for example =SUM(1, 5)

I would like to be able to create a formula for an Excel worksheet using a
list of dates and then subtracting one day and adding 3 years, 2 years, 2
years 3 months, 2 years 6 months and 3 years less 1 week to their respective
columns

I'm using this formula and looking for a way to simplify it.  
=SUM((COUNTIF(E5:E41,"DL380")*2),(COUNTIF(E5:E41,"DL580")*4)
(COUNTIF(E5:E41,"RP4400")*4), (COUNTIF(E5:E41,"DL585")*4))
As more models get added it will become tougher to maintain.  I'

How can I turn a formula like:
=COUNTIF('Person 1'!$C8,"Off")+COUNTIF('Person 2'!$C8,"Off")+COUNTIF('Person
3'!$C8,"Off")+COUNTIF('Person 4'!$C8,"Off")+COUNTIF('Person 5'!$C8,"Off")
Into (something like):

I just made my first pivot table. One column is a pivot-table-generated
"Total". I want to add a column that is the product of Total and another
pivot table column, but can't seem to figure out how to do this.  Help says
something about not being able to use Totals in ...

How do I get rid of rows of data (or even horizontal strings of cells) that
contain blank columns?

The data below shows a section of the information we are trying to subtotal.  
What I am looking for is a formula (or combination of formulas) that will
provide a subtotal for each specific item listed. An example is illustrated
on the first two SKUs.

I assume there is a quick and easy formula for this, but the only way
have figured out how to do it requires three forumlas in 3 seperat
cells.
Basically, I need to turn a 8 digit number into an IP address.  

Got a column of names and a corresponding column of dates. Am trying to
figure out how to write a formula that will a) select a pre-specified name
from the first column and count the number of times it occurs BASESD ON b)
the dates in the second column if they fall within a ...

Hello from Steved
Could I have a formula to acheive the below please.
Below is "Text"
3.10 PM to 1510

I have a running list of dates in column A, but there are some missing dates.
There is associated data in column B.   I'd like to put weekly averages
(Week is Sunday-Sat)  in column C and monthly averages in column D.
I can't just fill down a pattern of every 7 or 30 days, ...

I have a workbook where I would like to apply conditional formatting to an
entire row, depending on the condition in the first column.  I know how to
apply the formatting to the cell in the first column but not the rest of the
cells on that row.  E.g. something like if the ...

I have succesfully created a list using Data, Validation option.
This puts the name of the product in the cell C6, but I am trying to
find a way of automatically bringing the cost price of the product into
D6 and the retail price into E6.

I've been trying to make multiple IF statements but it says that I hav
too many arguements. The problem is, I need to have a calculation fo
my work.
Here's what I need to be done