My rows and columns are both numeric, i want to make one alpha, how can I do
that?

When updating the source date for a pivot table, and some categories being
no longer exist, they keep remaining in the label filter of the pivot table.
Refreshing the table updates the data area correctly, but no longer existing
rows, columns or report labels keep appearing in the ...

Using formula below to strip alpha & numeric characters from right side of
character string in ColB.  When copying formula to underlying cells, row
reference changes as expected but formula result does not reflect the new row
until I either double click to reset the formula, or ...

I have a worksheet that i need to copy for each day of the month and each
worksheet needs to be named for the corresponding day, however each saturday,
sunday, and monday needs to be on one tab.
For example, i have a tab for day 1 for March name "1" which i want to copy

One of my workbooks allways has the "calculate" message in the bottom left of
the message bar even though auto calculation is on.  This only happens to
this one workbook.  Any suggestions?

I have a worksheet that i need to copy for each day of the month and each
worksheet needs to be named for the corresponding day, however each saturday,
sunday, and monday needs to be on one tab.
For example, i have a tab for day 1 for March name "1" which i want to copy

I am newly to use excel 2007, why it will automatically copy the last text
that I had entered and paste to the next cell together with the new text?
What I mean if I typed 123 for one cell and entered, then I type abc on a new
cell, the worksheet will appears with 123abc? Pls adv ...

Attempting to create template, in Excel 2003, that will tab from one desired
fill in field to the next.  Have tried protecting the sheet, but then can't
either lock or unlock the cells desired.  Have saved as a template, deleted
extra unused sheets, but just am not getting it!!!  ...

Hello, I am having a tough time getting a document to display
percentages correctly.  For example, I want a percentage to show up as
"20%" but for whatever reason, when I type in "20" into the cell it
automatically kicks back 2000%.  I have cleared formats several times,

I need to add all values from each week into one sum per month.
For instance, below is some of my data as it's set up for my pivot table.
    A    B    C
1    Week    DEPTID    Week hrs

I need a formula that picks up anything 1-29 (not zero).  At least 1, but
less than 29.  I had =COUNTIF(Terminations!O:O,"<=29") was working fine,
except another formula is creating 0's (zeros) to come into this column.  The
zeros can be there, I just don't want them counted.

I am trying to do an IF equation but I have two values that I want to be
true, how would I go about this?   Basically I want 2 or 3 to equal “go” and
everything else equal “no go”.  I have tried to use something like this
                     IF((B3+B4)=2<>3,”no go”,”go”

Is it possible to restrict access to only one column of a spreadsheet?

I have a list of numbers:
10
15
200

I would liek to use sumif but use criteria from 2 columns instead of one. i
tried to use the conditional sum wizard in the add-ins but when I change
something it does not seem to work. Any ideas?
Thank you