Mac Forum / Applications / Excel / April 2005

Any idea why the following toggles back and forth nicely on Mac XL 2001 and
not on PC XL 2000
On the PC the shape moves once to the 100x100 position and then does not
budge - it is the same file on two different machines!

Please help - I've just spent another hour trying to fathom out Windows
windows as opposed to Mac windows work - I know I ought to address this to
the PC group but Mac users are more likely to come across this problem
posted yesterday

Please help with a few issues...
Is there a way for me to be able to enter military time in a cell
without using the colon (:)? When I format the cell using a custom
format of hhmm, and then enter a time, it just converts it to all zeros.

I am trying to create a spreadsheet dealing with daily nutrition.  I
want to be able to enter a food in the first column and the number of
servings in the second column, then have the rest of the row fill
automatically with appropriate values for calories, sodium, fat, etc.

In Excel 2004 VBA, the GetSaveAsFilename method, if try to set the FileFilter
arguement for the file types, the desired result will never come out.
The file type dropdown list will forever show all those default file types.
I haven't re-tested this on other versions of Mac Excel ...

Does there exist a version of Excel that works with Mac OX 9.x?  If so
where might I find it?
Thanks,
Duane Hannan

It's probably obvious and I've just missed it!
Visual basic
Using variables, in this case  RowNumber and ColNumber, I should like to
check whether or not the sum of the values in the following = 45

Variable in footer
I have =COUNTA(Bx:Bxx) in the spreadsheet in, let us say, A1 - it varies as
the number of rows change - I am counting surnames of members of a club in
this case (it does not matter if the same total appears on more than one

Footer date format
Can one vary the format of the date in a footer?
Mine comes out as dd/mm/yyyy whereas I should prefer d mmm YY but on
occasions might choose another format

Is there a way to have the full formula "appear" in an adjacent cell?   I
want to show my work on the hard copy of a test.
Thanks!

I have the Mac versions of Excel 2004 and Word 2004, but not part of the
Office 2004 suite. I want to create scripts (using VBA) in Excel, but I
can't seem to do this. Do I need the full Office suite to do this?

I have a G5 2.0DP with 1.5 Gig RAM running 10.3.8. I have Excel 11.1.1,
part of Office 2004.
I have a Workbook of about 300 k with many small entries. If I select a
cell and copy it, it will do it no problem the first time, and I can

Using Office 2004. Absolutely new to Excel.
After trying out a variety of password and website sign-in storage
utilities (like Password Retriever), I've decided I want to go back to
a more basic approach, and use an Excel Template.

I've spent TOO long on this.  I've got an excel file - created from an
Access database.  The key to this problem is that we do NOT want tor
recreate the file - we've already put too much work into it.
In front of every data field is the apostrophe character (or what looks

When I do this on a pc it works
ActiveSheet.Shapes("F221FCHECK").Select
   Selection.ShapeRange.Fill.Visible = msoTrue
   Selection.ShapeRange.Fill.Solid