In excel 2000 I would like to be able to read in different values for AK into the following cell entry:  ='Feb01-04'!$AK39
Stated another way, I would like to rewrite the above cell reference so that the value AK is read from another source cell.
For example I might type AX ...

Hi, having trouble have one column of figures produced by formula when I total up at the bottom of the sheet they are out by .02 do not know  how to solve this problem, I have been into format cells  to 2 decimal places but still differs.

I know you can use the little ' to turn a numberfield,
with leading zero's into a text field, but I have several
1000 lines where I need this added. Is there a simple way
to add these to cells with number values already in them?

is it possible to round down the result of a
multiplication formula in the same cell and if possible
what would the formula look like?

howdy, all :) maybe someone can help me.
i have an interesting "problem" and maybe someone has the answer. i am using
excel.
i am trying to figure out a formula/function which can convert a small set

I need a formula that will automaticaly
update handicaps using the last three
scores entered.  
ex:  A1   B1   C1   D1   E1                              formula

In my workbook "Contacts.xls" I want to import cells from "Sales.xls"
I work with macro's, but can't find the formula.
Hope someone can give me an text example
Thanks

I am an excel novice, developing price lists to use for my invoices
p.o.s, inventories, etc. In my look-up formulas, how can I have unuse
spaces return a blank space instead of #N/A?
I realize this question is sub-basic, but my need to know ha

When I save a file in Excel or for that matter Word, I am
unable to open the file(s). I get a prompt saying that 'my
virus scanner has detected a problem with the file'. I
don't know of any virus scanner and I just saved the file a

I can't set the cell value to H:MM without it being a time stamp (ex:
am/pm).  Hence they will not add properly when summed.  It turns to time
no matter what I select.  Even tried custom options.  This is something
that I've wrestled with for years!  Please help

I am using Excel 97.  I am not an advance user by any means.
If I have a spreadsheet with numeric entries, is it possible to apply a same
mathematical formula to all the highlighted entries?  For example, if I had
100 numeric entries (10 rows by 10 columns) but I want to change all ...

Is it possible to put a name in place of the "A" at the top of the column? How do I do it?

Is there a way to number each row in Excel so that when
it prints out the rows all have numbers? I couldn't find
it in Msft online Help but I guess that's no surprise.
thanks!

I'm transferring data from Excel to Access.  One of the columns in Excel
is going to be the primary key in Access, but right now there are
redundancies in it.  Is there any way I can use Excel to eliminate
reduncancies in a column?  Or do I have to eyeball it?

I want to restrict values in a particular column based on the value in other
column. For eg.
if column A has value int then column B should be restricted to values
1,2,3,4,5