How do I install the below function in an excel spreadsheet? i received it
as suggestion to handle my question below!
Function ShowFormula(MyCell)
 ShowFormula = MyCell.Address & "  " & MyCell.Formula

Every time that I try to change the number format I can only start at 01.  I
must start my numbering at 0001 and shy of manually typing in every number (
I need 2400) I don't know how to do it.  Can anyone help?  Thanx.

Say I have the following sheet
      A
1      c
2      a

I have Office 03 all updated. I have a file with columns of data which has
the first row of the sheet as headers for the columns of data. Basically, I
need to take this top to bottom organization and make it left to right
instead. Is there a way to do this easily in Excel? I want ...

I have a table in the middle of my sheet.  The background is just the
normal white cells.  I want to change the entire background to a solid
color, but I just can't get it to work.
Here is what I tried.  I highlighted my table, held down the ctrl key,

I have a spreadsheet with a formula that looks at another sheet
=(Original!C56)
Most items here are numbers i.e.
120257577

How can I convert the number scores of my students into
letter grade? For example 91-100 is A, 81-90 is B, 71-80
is C etc.  Thank you for your advice.

I have a column in one worksheet and a column in another worksheet
(both in the same workbook). The list is huge and I need to check one
column against another for duplicates and remove the duplicate from
one column

have a summary table running using this formula:
=IF($B45="","",F11+R11+AD11+AP11+BB11+BN11+BZ11); copied down several
columns
B45-B51 contains descriptions of lines codes such as KIT KAT CHUNKY

Dear Clever People,
I hope this is not the "silly question of the day".
We were wondering (when you have multiple workbooks open and you close one
workbook)  why are all other workbooks forced to be closed, too?

Is there any way to securly lock hidden columns so they cannot be
re-opened by the reciepient when faxing worksheets?
Thank you
Joanne

I have a summary table running using this formula:
=IF($B45="","",F11+R11+AD11+AP11+BB11+BN11+BZ11)
B45-B51 contains linecodes for items such as 12021756, there are then
other vlooks running.

I am creating, from an Access97 function, an xls file from an xls template.
The template is 17MB. I've been working on this project for a couple of days.
The first files I created were approx 27MB in size. Now, all of a sudden, for
no apparent reason, using a similar sized dataset ...

a very inexperienced Excel user needs any help I can get.
I have supplier item data for yr 1 and yr 2.  Year 2 has some price
ammendments and some additional items.
What formula can I use to identify any changes in year2 data?

I got some help asking this in the Access group but I can make it work
quite the way i need it to so here it goes...
I have an Access database that contains job #'s and the associated
project name among other fields.  Now I want to create an employee