Mac Forum / Applications / Excel / February 2006

For the first time a blue area to the left of my worksheet in the
current open window appears with some symbols. At top are numbers,
which if I click, a dialogue comes up telling me it can't move items
off the worksheet. The second is a switch of some kind that hides and

I have 2 columns of names, 1 master list (A), 2nd column (B) contains
names that need to have any that are duplicate to column a be removed.
I need to keep the new names in B isolated so I can add them to an
external list on our server before adding them to the master (A) Is

I am creating a new toolbar which I want to go horizontal (especially as I
am using text on the button) but it will not go horizontal, it stays
vertical. It means I cannot use all the seven buttons I want to go on this
toolbar.

I have Excel 2004 11.2.0 for Mac and run it on Tiger 10.4.4. but cant
get the comma to be as a decimal separator.
All is set in system preferences (international>formats), but it wont
pick it up. It always stays on US setings, I mean comma as a thousand

This is a problem I encountered and also a fix for it. I just thought
I'd mention this for anybody else with a similar problem.
Product: Office (Excel) 2004 for Mac (11.2 (050714))
Operating System: OSX Phanter & Tiger. Potentially others.

I am using Excel X for Mac SR1, Mac OS10.4.4
I have created some Combo Boxes from the Forms Toolbar and want to
change some of the characteristics.
1. The height of the box, seems to be stuck on 0.67cm. I change it in

I have a calculation that generates the number of hours required to complete
an industrial operation.  We now want to express the duration in terms of
elapsed calendar days, and the facility does not operate on weekends.
For example:

I have a problem using "find next" in macros that I create on my mac.
The problem is that opening the find dialog and choosing "Search by
columns" before selecting "find next" does not retain the columns
option in the actual macro.  (I know the Windoze version doesn't have

I can't get VBA to close an Excel file. Using Office 2004 on Macintosh
10.3.9.
The file opens just fine, but won't close.
In fact, when I iterate over all the open Excel workbooks, I can't get any

I should know better!
Column of ages named 'Age'
30-39   =countif(and(age<30,age>40)....no that's no good
40-49

I just upgraded to Office 2004 to be able to get an AppleScript in Entourage
to kick off a VBA macro in Excel. But no luck.
To test things, I created an Excel file ("test.xls") with a one-line VBA
macro named "test." It just puts up a dialog box with the message "success."

New to this group.
Please help me in changing the date system in Excel permanently to 1900
date system.
Now everytime I start new excel file I have to change manually to 1900

Can someone please help me with the formula to count part of info in a
column? Ex: All cells contain  combinations of colors "red blue green"
and "green yellow red" and I only need to count the ones that have
"red" in them. Is this a version of a "countif" formula? Any help is

I'm doing a catalog with Excel, Word, and InDesign. Tracking all the
products and their info in Excel, merging through Word and into
InDesign.
I have the measurements all in Excel and are showing nicely as

Hey all, new to the group.
I have an interesting problem that is driving me quite crazy right now.
When my users are opening excel docs sent from windows users with
Macros, they are getting a "File Format No Longer Supported" error.