Mac Forum / Applications / Excel / December 2005

I've been using excel of various vintages for a very long time, but
recently something happened in the normal view that I have never seen
before, and cannot get rid of it.  Not sure if this is a bug, or my
toddler son has pressed some weird key/mousing combination to get

I'm a newbie. I want to enter numbers such as 4.21 , 4.00, 4.20, and
0.00 .I can't find a way or setting to do this.
4.00 shows up as 4, 0.00 shows as 0.
Can anyone help?

I need help fixing a problem.
I have an Excel workbook with multiple worksheets--one for each teacher in
my school.  I have some data on one worksheet that I want to paste as a link
to another worksheet so that it will automatically update when the

How can I get the same header/footer to display on multiple worksheets
within the same workbook?
Thank you for your help.

I need to determine whether x is odd or even in a macro
= MOD(x, 2) works in a spreadsheet but
If MOD(x,2) = 1 then
etc

I have Mac users running Excel 98 for Mac that save files to the fileserver
to be opened by MS users running Excel 2003.  The columns that have dates
that look like:
10/24/2005  shows as #####  [thats five #'s no matter that the date was

I would like to compare the supplier name in my recordset whether
contains the same data I stored in the array.
How should I do the comparison using array i had store and show
whatever related to supplier name in concatenated string. For