Mac Forum / Applications / Excel / April 2005

Hey, so I've a workbook with a few hundred entries that I want to
hyperlink to local files on a CD.  For some reason, after I've opened
the .xls file and hyperlinked one cell's contents to a file on the CD,
if I try to hyperlink another cell, when I try to browse to a file

I am unable to change the formatting of a column to zip, despite having
tried every methid I can think of. I still get an error message from
each cell in the column, but now the pop-up field telling me what the
error is doesn't work either.

I receive large spreadsheets with numerous built-in macros from
companies I work with.  These macros will not work when I open them
using MS Office/Excel.  I have been advised to go to
Tools>Macros>Support and select Medium Security.  Obviously they think

Greetings Group,
I have created an Excel spreadsheet for keeping track of a small phone
directory. I then turn this into a PDF for the web, using either
Acrobat Professional or Apple's built-in "Save As PDF" from the print

We¹re having issues with Mac Excel (X and 2004) saving tab-delimited text
files that are also used by PCs.
The issue is that when the PCs open them and try to upload them to a server
for data import, there are extra characters inserted by the Mac versions of

Excell cellallows one one digit to be typed.  Example if I type 36 the
cell shows the last digit typed.

I have a column of numbers, many of which are greater than 1000, and a
few of which are not integers (and need to display to the right of the
decimal point). I'd like to display the "thousands separator" (a comma
in this case) to make it easier to read the larger numbers. The ...

I have read the information posted in 2001 about  the lost formula bar
upon opening Excel.  I have had a recurring problem about losing my
formula toolbar on a recurring basis, usually when I fall asleep while
working at the computer late at night. When I wake up the formula bar

Help have a weird Excel / networking issue that I need a hand with.
The Network:
1 x G5 iMac 10.3.8, running Office 2004 with latest patches sharing the
contents of its "documents" folder. Connected via AirPort to an

I would have expected a one-step cross- or dot-product function  in
Excel, since most other simple matrix algebra functions are
represented, but I can't seem to find one.  Because laziness is the
step-mother of invention, I thought I'd ask around if anyone knows

I am having trouble establishing a formula and copying it to a column.
Here is what I have been doing:
1) Go to "Insert" in the menu bar
2) Select "Function"

I am trying to use Applescript to update a List Manager list.
On worksheet 1 I have the data collected from other spreadsheets on
columns A-E, rows 1-100. I created a list on worksheet 2 that
corresponds to that range.

There must be a slicker way of formatting a column the same as another
elsewhere in the same sheet than
Select and copying column X
the

How do i calculate a total of 4 columns of hours and minutes? Not
"time"
For example, im keeping track of the amount of time i spend on 4
seperate projects. if i spend:

Good old Mac XL has the wonderful facility for moving columns around
Select col
Cmnd (or whatever you call the Apple key) + X
Click the head of the col you want it moved in front of