Mac Forum / Applications / Excel / June 2006

I can post a file demonstrating this bug.
When you set your preferences to use 'labels in formulas' [sic], it
permits nice and readable formulae.
I generally select the area in question, then use 'create names' using

I have a text file with <TAB>s in between sections of the text that I
would like put into different Excel columns.
When I open the text file in Excel it simply places all text into
arbritrary columns. How can I get it to place it into columns based on

Does anyone know how to backup an Excel spreadsheet to a rewriteable
disk?
Is the only way to save a copy outside the computer is to backup the
entire computer to an external hard drive?

I'm trying to solve a problem whereby dates are being transferred to their
1904 system value when I don't want them to.
Let's say we have the following cells:
A1 contains 01-Mar-06      [01/03/2006 with custom format dd-mmm-yy]

Platform:  12" iBook G4, OS X 10.4.6, Excel 11.2.3.
When I fill in part of a column with values, select those cells, and drag
the corner to fill in the rest of the column with the data, I get what
appears to be rounding errors.

Problem as in topic. I currently live in US, so as one can guess, I
need US data format it means:
10,000.00
Actually, somehow the format under my excel is european style:

Hiya,
Is it possible to have conditional formatting for more than 3
colours/conditions?
thanks for your help!

I've written some XLL addins for the NT/XP version of Excel. I'd like to be
able to port these to the Mac version. Unfortunately, I can't find any
documentation/links on how to going about doing this. Has anyone got any
ideas?

I've been reading Edward Tufte's "The Visual Display of Quantitative
Information" (which, by the way, I can whole heartedly recommend to anyone
with a personal/professional interest in statistical graphics).
Anyway, I'd love to implement some of his ideas. For example - using a

I have always like to format my date to show as year-month-day (2006-06-15). I have set it to show in that format
whenever I hit Control + : within a cell where I would like to have today's date shown. It has been working without any
problem until yesterday. Now whenever I want a ...

I'm trying to find a way of comparing two excel files that are lists of
e mail addresses, 1 has about 20k the other newer file has about a
1000. I need to weed out any duplicates before merging the two files.
Any help or suggestions would be much appreciated

I was wondering if anyone knew how AppleScript will look like in Office
2007.  It was recordable in Office X, and then they changed it to be
more Visual Basic-like in Office 2004.  How will it look in Office
2007?

I am working on an InDesign document that requires a lot of copying and
pasting from Excel to InDesign.
Excel is giving me frequent "Out of Memory" errors. They always come in
pairs. Two "OK" boxes to dismiss, then the copy works without incident. The

One of my machines, a MBP 2.16 with 2 GB or ram, has been having
strange problems with Excel.  Clicking on a cell with the mouse does
not show the formual (or value) in the formula bar.  It is just blank.
If you then hit "enter" (not "return", which would move it) it shows

I noticed this as soon as I received the MacBook (about 6 weeks ago).
If you use two fingers on the trackpad to scroll in Excel, you can't
scroll down slowly. Fast scrolling works, but trying to scroll down
slowly just scrolls upwards. Equally, while you can scroll left and