Mac Forum / Applications / Excel / April 2006

I'm running Office:Mac 2004
For some reason, inputting '0.4' immediately resets to '0,4' (note the
comma) - as in France.
(This doesn't show up in any other applications, with the exception of

In Excel 2004, when one brings up the Find dialog, the search will be
performed by rows unless one changes this choice to columns. Is there a way
to change the default to search by columns? Thanks in advance for all
replies.

I'm sure the instruction is somewhere in the help files, but I can't
find it. How do I start a new line within a cell (e.g., when entering
text)?  On the PC, it's alt-enter or ctrl-enter.  Thanks!

Excel used to work. But now when I try to open Excel a file opens but I
get the color wheel and it hangs.  Oddly, this only happens on my
account.  When I go to my husband's account it doesn't happen.  I
reinstalled Office but not only did it not fix the problem but now I

Is it possible when using graphs in Excel 2000, to keep the title
static at a specific size.
I have a lot of graphs on a sheet and find that when I move the graph
or resize it - I seem to lose the heading behind the graph or it seems

Someone posted this same problem but didn't get an answer (see below):
the row height autoFit doesn't work for all rows (Excel 2004 v11.2, OS
X 10.3.9).  This is a consistent bug where most, but not all, rows will
revise to show all text when using the AutoFit command.

Can excel be part of some automation.
Here is what I need:
I send an spreadsheet with 1000 image file names.
An editor send back a spreadsheet with favorite 100 (random))

I have created some in-cell dropdown menus that validate to a list in the
same sheet.  I have copied the worksheet within the same workbook.  The
drop-down menus don't work on the copied sheets.  The list is still there,
and the data still needs to be validated in the cell, but the ...

What I have been doing lately?!? I have been creating an Excel database
(Office for Mac 2004) including several international media companies
and the movies/TV programs produced by them, plus some additional
information (evaluation of the program, length, etc.). Thus, this

I get this message when I try to use Mac Excel 2004 (latest build) to
open certain files created in MS Office Excel for the PC. The files do
open on PC Excel.
Any ideas?

I have been having difficulty with sorting the data in my excel document, as
the "Sort" option is not highlighted in the "Data" menu.  This began with the
document name in the top bar being followed by the word [Group], in the
square parenthesis.  I don't know how or who changed ...

n the VBA help file, when you search for "export chart", it offers this
example:
 Charts(1).Export _
                 FileName:="current_sales.gif", FilterName:="GIF"

A couple of months ago I asked how to create a new command bar button,
which is documented incorrectly on page 30 of
Excel2004AppleScriptRef.pdf.  Through other sources I found this is how
to execute that particular sample:

There seems to be a bug that I can consistently replicate with the
trace dependent function on Excel 2004.  When the error occurs, it
fails to trace a dependent cell if the function is called through the
taskbar, but it works correctly if called from the menu Tools /

I'm adding a button to a userform at runtime using the following code:
Private Sub UserForm_Activate()
   Dim Mycmd As Control
   Set Mycmd = Controls.Add("Forms.CommandButton.1", "CommandButton2",