Mac Forum / Applications / Excel / September 2006

I am having to manipulate large data streams, thousands of cells, and
need to be able to fill a column without using the fill handle, as it
takes just too long.
Anyone have an idea?

In this formula,    =IF(I20=14.58,"C","R")
I20 is 14.58 (actually 14.5799999) yet "R" is returned.  Clicking the equal
sign when the formula is displayed, the dialogue box says that  indeed it is
false.  Apparently it's not close enough to 14.58.

I've got a problem with my XL for Mac - I've tried absolutely
everything I can think of and can't seem to fix it...
The basic problem is that dates appear in french (specifically, the
month name).  This is despite the fact that I've set every preference I

I have two worksheets (2005) and (2006) with similar data headings
Column A has unique identifiers for each row in both sheets.
I'd like to capture information from every entry in 2005 columns D,E,F and copy
to columns D.E,F in the corresponding row in 2006.  

Mac OS X 10.4.7
MS Office for Mac Excel 11.2.5
Hi
with Ctrl-. I should be able to enter the current date into a cell.

I can't seem to click into a cell with my mouse on my mac, any ideas
what I've done and how I can fix it?

When opening up an excel file I get the dialogue box asking me if I
want to enable or disable macros. However, when looking in
tools->macros, there are no macros present.  Is there somewhere else I
can look for "phantom" macros, like there are with phantom links.  I

I'm using the early version of Excel (Office X for Mac)
Is it possible to "set preferences" for the Excel window in Ofice X so
that it remembers (when opening files or "new from template')  the
exact same location and dimensions of the window containing the data?

We collect data from a form available on the Internet. This form stores the
submitted data into a .csv file. When we open this file with Excel (Excel
2004 v. 11.1 for Mac) the European special characters shows as different
symbols. The characters display nicely in the .csv file ...

I took my spreadsheet home over the weekend to finish it for work on Monday.  
At work I can run this macro without problem.  It doesn't like saving as a
text file.  The history of this problem is without both saves it saves the
original and turns it into a text file.

How do I adapt the "IF/THEN" statement to capture the first or second
line column headers and convert them? For example,
IF Worksheet.Column = "Name" THEN
    Name = A

I'm trying to use excel to spell out color words for my class so I can
cut them apart and have the kids put them back together.  I have one
letter in each cell.  My problem is that the lowercase i keeps changing
to an uppercase i.  I've never had this problem when I put words in the

I need to do what I would think is a simple thing: save a Mac Excel
file (Office 2004 version 11.2.5 using OSX 10.3.9) to a tab-delimited
text file [TDTF] (to import into Final Cut Pro).  (1) My default Excel
file has three sheets. If I try to save this as a TDTF, it tells me

I am a weather hobbyist using excel, and find it very useful, and more time
saving than Appleworks spreadsheets.  I use Camino as my default browser,
which by the way is very good.  The problem I have is linking to web pages,
excel will only use IE for bringing up bookmarks and ...

I am a new user to Mac, and to be honest I quite like it. I have a
question regarding excel for mac.
I am using office x, and my chart wizard button will not highlight, and
I want to put a graph into an excel spreadsheet to show separation of