Mac Forum / Applications / Excel / February 2005

G3 - OS 9.1 - XL 2000
My keyboard (actually both becasue the same thing is happening with a spare)
has a mind of its own - in the last few days (I must have done something
unknowingly) the left, right, up and down keys no longer move me from one

Just wondering if anyone might no why conditional formatting would work
right on some columns and not on others. I have a document that has many
fields the conditional formatting for contains works on all the columns
except like 2. It will work to do a specific but not if I use ...

Does anyone remember a Mac spreadsheet program by the name of WINGZ? If
so, do you know what ever happened to it? Not to slight Excel, but @
the time Wingz was a revolutionary piece of work.

(I've just pasted this into a Word MG email!)
There are many occasions when I want to use a variable in a spreadsheet
formula ­ for instance:
R1C1 might have =COUNT(R9C:R100C) giving the result 62 since, on this

I'm trying to export a spreadsheet as a CSV file, but need to change
the delimiting character from a comma to a semi-colon.  I know this is
straightforward on a PC as it's a setting of the operating system, but
can't seem to find any way on the Mac?

I'm trying to help my kid's school home and school club better use Excel
for tracking a walking program.
They use Excel spreadsheets to calculate the number of laps/miles walked
each week.  Each weekend they add a new column, entering the number of

Recently there's been many questions related to Excel workbooks exchanged
between Macintosh and Windows. See the following link for common answers
(that's a very long link, so be sure to copy everything before pasting in
the browser's address bar)

I'm looking for a way to dynamically create an SQL database query in
visual basic on the mac under OSX.  From everything I've read, this
feature doesn't exist.  However, I found SQL.REQUEST under Excel X help.
 It claims to to be able to send a request to either dBASE, SQL ...

Hello I am trying to set up a job work time sheet for time spent on specific
jobs and I want to total up my hours I tried =Sumc(iC:CH) but it says that
it wont work with empty cells how do you get it to ignore empty cells or
cells that havent had a value added yet

I am trying to produce an amortization worksheet for a 48 month long car
loan.  My ending results do not agree with the notes'.  Is there a reliable
source where I can get a sample amortization worksheet? I tried an
annualized approach but that also did not come out to the amount on ...

I am having a problem with excel hanging up will sorting colums in a
spreadsheet.  The sheet is about 12000 lines long.  When ever I sort a
column it crunches for 30 minutes before it completes.  In my pc world
it takes all of 5 seconds Please help

Problem revised:
Saving "editions" (publishing function within a file) has suddenly slowed to
a crawl.
Additional information:

I am  using Microsoft Excel for mac.
I want to copy a spreadsheet onto a disc but it keeps copying as a read
only file.
how do I copy it correctly so that my accountant may work with it?

I am designing some spreadsheet tools on a Mac that will be used by a
primarily Windows Laptop audience.  When I sent my first draft for review,
the sheets that fit perfectly in my Powerbook monitor were oversized for the
PC by about 150%.