Mac Forum / Applications / Excel / July 2005

Is it possible, in Excel 2004, to produce a list such that the entries
within that list contain lists for some fields?
An example of the format which I wish to create would be a list of the
customers of a computer repair shop with a small history of the

Is it possible, in Excel 2004, to produce a list such that the entries
within that list contain lists for some fields?
An example of the format which I wish to create would be a list of the
customers of a computer repair shop with a small history of the

Excel 10.1.6, Tiger 10.4.2, G5
Running a huge database on horse racing and would like a unique sequence
Number corresponding to date, race number and horse number.
Tried =CONCATENATE(B4,D4,G4)--- (B4=Date, D4=Race number, G4=Horse number)

I'm using 11.1.1, and even after I toggle individual cells for protection,
they are editable after I protect the sheet or entire workbook. Am I missing
something?

Is it possible to acquire a plugin or better still a formulae to calculate
the above in excel for Mac. I am aware of such tools in Excel for Windows.
TIA
John Holt

I am currently working with Excel 2004 for the Mac and created a pivot
table which  worked fine. However, I made a number of format changes to
make the report look better and whenever I refresh the data I lose all
the formatting.

I remember from over 10 years ago that Excel used to have the ability
to automatically run a (startup) macro imbedded within a workbook when
the workbook was opened.
Does anyone know if this capability still exists in Excel 2000? If so,

I am wondering if there is any way to do something.  I am creating a
schedule. I have created a list of employee shifts that need to be
filled every day. I have also made a schedule with all of my employees
names going down one column and the dates (Mon.-Sun.) going across.

Recently when I try to open excel by selecting a xls file, it opens up
6 or 7 files. Some are pdfs, doc etc. I have no idea what is going on.
Any suggestions

I have just installed Office 2004 on my new mini mac and when using
excel, I don't have the same ability I have with a pc to access the
drop down menus with the keyboard.  I would like to know if the Mac
program has the same ability to hit the alt key and then follow the

Have just installed office 2004 for mac. everything worked fine until I
tried my new excel. It is so strange and impossible to understand. When
writing a number to any cell in a sheet excel automatically devides the
number with 100. When writing 100 and push the enter button the ...

Help. I have a quanity of Excel worksheets, Actually they are products
that I sell. Each worksheet has its own title. When I am working in the
worksheet " Gidjets" I would like to go directly to " Widjets" with out
going back to my main index. I work with a PC at the office and a ...

Is there an equivalent "Research Task Pane" on the Mac version 2004
that exists on the PC Excel 2003 version?
I'm doing some exercises on the PC Excel dealing with inserting stock
prices from companies using this task pane and want to try it on the

Hello..
I am new to this group and have a power mac G5.
I want to know if there is a stand alone version of excel for mac. I do
not want to buy or install the complete office package, as i only need

I am trying to idiot-proof a template for someone and I want the cells
to treat email address and URL's as plain text and not make automatic
hyperlinks.
Is there a way to do this in preferences? I know you can go cell by cell