I have a spreadsheet with 20071123 is in number format.  I am trying to
covert it so that excel will see those numbers as a date.  It is not text but
in number format.  How do I change this to make it read 11/23/2007

I have a simple tracking sheet that we have people entering overtime
usage in to. I am trying to summarize this info with a basic
pivotchart and group it by month, day, trade, etc.
Anyway, there is a column for inputing the date in to. These dates

using the formula,
=CONCATENATE("Text = ",58.5," + ",F33,)
everything is perfect except the F33 cell is reading with many decimal
points.  i have formatted the cell with the correct number of decimal points,

I have a spreadsheet of weekly reported data going back 3 years.
Currently the dates are reported in mm/dd/yyyy format and I want to be
able to sort the activities chronologically. Is there any way I can
apply a yyyy/mm/dd mask to my date column so that the SORT function

I've got a table with columns of Sales Reps names and their Total Sales.
I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them ...

I have the following table.
part                                   start    mid    end
ABCD plan                                   01-Jan    01-Feb    01-Mar
        actual/projected    01-Jan    05-Feb    05-Mar

Thanks in advance for your help!
I have created a spreadsheet to inventory equipment that have GPS units -
I need help in working through some formatting or Macro, ???
I have placed my master equipment listing in Row B

I am trying to formulate a cell to figure averages from cells that have
averages.
My current formula reads
=AVERAGE(D33,G33,J33,M33,P33,S33,V33,Y33)

I have data arranged like this:
a              b                               c               d            
e             f
                assembly           

I want my spreadsheet to return YESTERDAY's date, not TODAY's.
I believe it's not possible to embed TODAY() in a formula, so can anyone
tell me how to return YESTERDAY'S date into a cell?
Thank you.

I am setting up a form for multiple users to use, however I would like them
to be able to move through the form by tabbing or enter to select fields,
i.e. tab from cell a4 to g3 to h20, etc.  Can this be done.
Confused

Hi, how can I sum unique values within a range where some cells are
blank?
An example:
   A

I have a spreadsheet that I want to show the following things:
Max approval amount
Year-to-date expenses
Amount left to spend

I have a spreadsheet with B9:B39 containing the numbers 1 to 31, B4 =  a
month and B5 =  a Year.
The month and year cells are validated so the user chooses "April" etc from
a drop down list and likewise "2008" from a dropdown list in the year cell.

Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.