Mac Forum / Applications / Excel / August 2005

I need some help with a work schedule done in Excel.
The schedule is not very complex; however, when multiple changes to the
schedule are made for vacations ect, it becomes a garbled mess & I find
that some problems arise for me to be able to mentally determine how

this is probably an extremely simple thing, but I can't find the
answer...
I am trying to combine columns (i.e. I have a spreadsheet which has
columns for first & last names, which I want to combine into one field)

Program recently started using comma instead of decimals. Can't seem to find
where to change it back??

This one is a bit hard to explain, but I'll do my best. I've got this
Excel document that has a number of formulas. I've got the contents of
column A adding up. If I change one of the numbers in column A, the
total doesn't change. If I copy the formula from column A over to

Where/what is a good source for help on custom formats where I can get
explainations on how to create them and what all the symbols mean (such
as the "@" symbol etc)?

This a tough one. I am working on a presentation for Spanish speaking
audiences. The problem is that numbers in English have a different
format than numbers in Spanish. For example, 23,789.25 in English is
23.789,25 in Spanish. That is the decimal and thousands separators qre

Is there an easy way to repeat a string (say "+-") so that it repeats itself
as many times as necessary to fill cell?
From memory, I believe that Lotus 123 had some shortcut way (perhaps "\+-")
that did just this. Is there something similar in Excel?

I have an Excel document that just won't save for me.  Actually, when
my coworker sends me the exact same document I can work in it, make
changes, and even save the changes.  But, when I open the document up
again it won't let me save anything.  It just keeps saying "Document

The same Excel doc prints fine in Excel vX (the previous version).
After defining the print area and setting the PostScript printer in
Page Setup... and choosing 1 by 1...it doesn't resize to 1 page.
To the same printer with Excel vX no problemo?

Using  Excel2003 on WindowsXP, i have developed some VBA code on an
Excel file. This Excel is quite simple, it contains several sheets, drop
down list, buttons,...
It's possible to open it on Tiger/Excel2004, but after a while (several

I have a list of partnumbers that are having either 10 digit or 13
digit. I wanted to extract only the partnumbers with 10 digit from the
list. How do I do it in excel in a single step?
Thanks in advance.

Is there a way, other than using FORM check boxes, to fill a cell with
an "X" so that it takes up the entire cell and looks like a check box? I
thought I've seen this done somewhere, but I can't seem to figure out
how to do it. I don't want to just type an X in it and have it ...

I am using OS X 10..3.9 with all known updates installed on a G4 Cube.
I have installed Office 2004 Mac.  Now Excel, Word and Powerpoint will
not open.  I get the ubiquitous "Microsoft Excel(Word, Powerpoint) has
encountered a problem and must close.  We are sorry for the

I purchased a set of spread sheet templates from the Internet. I paid full
price.
But I need to customize the templates. When I try to enter a new cell name
I get an ³unprotect sheet² window which asks for a password.

This is the first time I've tried using Excel 2004 and it's constantly
hanging and taking 80% or more of CPU. It also sucks up greater than
450 megs of RAM.
It's a small file < 1mb and hardly any data, just clicking "sort" makes