Mac Forum / Applications / Excel / March 2006

Can someone please tell me how to use the sum function to add values in
cell that have text in them as well?  i know excel for pcs have the
option of SUM and SUMA, how do I add just the numbers and ignore the
text?

Hi Buddy,
I cannot set Excel 2004 as default application for xlt files. If I
hightlight one xlt file and click Get Info, Excel 2004 is gray out in the
application list. However, other Office 2004 applications can be selected.

Excel 2004, SP 11.2.3
PowerBook G4, 2 GB RAM, OS X 10.3.9
I've been working on a complex Excel financial model for a month now. I was
putting the final touches on the whole thing this afternoon when it suddenly

can anyone help?
I want to stop users opening a particular workbook and then saving that
workbook as "master.xls".
So if they open the document called master.xls, if any save action is

When I copy and then paste something I get that little pop-up menu with
formatting options, like:
Keep Source Formatting
Match Destination Formatting

When I copy and then paste something I get that little pop-up menu with
formatting options, like:
Keep Source Formatting
Match Destination Formatting

I¹m trying to run a Windows originated Excel spreadsheet with visual basic
embedded commands on Office 2004.  The Mactopia website offers a vba
converter for Office 2004, but only downloads the one for Office X which
will not install.

f2 to enter cells and control apostrophie to insert a date dont work on
mac what are the mac equivilents to these?

I am trying to get excel 2004 to recognise my dates in the dd/mm/yyyy
format. i have changed the settings in the preferences on the system to
reflect this yet excel still instits on formating dates mm/dd/yyy. can
any one tell me how to fix this?

I have monthly data in columns from 1990 to 2005. I also have an annual
column which shows the total of 12-months data as summary. I grouped them
through (Data>Group and Outline>Group) so that I can observe only annual
values by collapsing the monthly numbers with (+).

try this on an AutoFilter'ed worksheet in Excel X:
Edit>Clear>Formats
Assign cell shading pattern
Sort using AutoFilter

I have used the SUBTOTAL command to insert subtotals in rows wherever a
particular variable breaks. Now I'd like to create a table containing
only the subtotals, which will eventually move to Word. As it happens,
before it moves to Word, I might want to transpose it.

I just started the fascinating world of programming with Microsoft Visual
Basic version 11.2.  I have Office 2004 version 11.2.3.
I have noticed that there is a problem with tabing from one control box to
another.  It only goes once and then stops.

I am writing a formula to calculate the last and next month end e.g. if I
enter 28-02-06, the expected result will be liked 31-01-06 and 31-03-06.  
28-02-06 will be stored in cell A1, and my expected result will be displayed
in A2 & A3.  My formular is liked " =A1-31 , = A1+31.  ...

I have an old version of Excel, 98, running in Classic on a 400 MHZ G4.
I know next to nothing about how to use it, but lately I'm having to
learn a bit. How do you get the darn program to add up the numbers in a
column to give you a Grand Total at the bottom? Someone please help. ...