We run a couple of spreadsheet 'templates' to extract data from a database
and generate some reports.
I updated Office Professional 2002XP to Office Professional 2003 last week
to be fully compatible with our Tablet PC's in the field and when we tried

I have a worksheet where I want to have the current date with a label in the
same cell.
Date: 01/01/2008
I tried ="Date:"&Today() but it just gave me Date:39473.

I noticed that when you edit comment you can sellect its position and next
time you edit it its on same position, although when its show its alway's on
upper right part of cell, can you somehow use position you set while edited
it when displaying comment?

i am using following vlookup, but when there isn't lookup value then coming
out O which i don't want !
=IF($J15="","",IF(ISNA(VLOOKUP($J15,Header3,2,)),"",VLOOKUP($J15,Header3,2,)))
thanks in advance.

I have a table that has data in it. I would like to be able to change the
Column number and the Row Number to change what displays in A4. Is there an
easy way to do this?  If I would type in Column 4 row 10 I would get Test7 in
A4 Thanks! Jeff

How do I convert total amount figures in excel to the next colum

I have over 1000 email addresses entered into individual Excel cells so I can
sort them.  How do I create 1 email distribution list from all of these
cells?  Thanks!

After I sort ascending a worksheet within a workbook the first 30 rows
are blank.
I have a workbook with 4 worksheets and I want info to update from the
first one through all the others so I highlight A1 - 60L and paste

I have a macro that clears the contents of a range of cells; however, I would
like to keep the formulas in certain cells, just clear the data....how can I
do this?  Thanks.
'Clear User Lists on Control Sheet

Does anyone know how to create a worksheet that will automatically hide rows
that have zero values when you want to print?

I know there's a custom cell format that I can use to create the equivalent
of a "dot leader" in an Excel Cell but I can't remember what it is.

I'm getting an error "N/A" in the cell this formula is located in because
nothing is populated in the first column.  How do I "" the error?
Thanks.
=VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)

I have a table that contains the following sales data:
AccountName   ReportingYear    Revenue
There are 2 years in the data and account name is repeated in the case of
multiple sales to one customer.  I want to display the following in a Pivot

I have a 2-column, 4-row matrix/table that looks like
     c1   c2
r1  bob   x
r2  ed

We've been going through a list and shading certain cells colors based on
responses we get from our clients.  Red for not interested, yellow for left a
message, etc.
I know it's possible to tally the TEXT in a cell, but is it likewise