Mac Forum / Applications / Excel / August 2006

I've been using Excel 2004 for Mac (11.2.5) for quite some time.  I
continue to have problems pasting formulas.  I copy a formula and paste
it into a cell.  If it try to paste it a couple of times into different
cells, it eventually fails.  Excel will paste the cell values instead

I am using Excel 2004 with OS X 10.4.7 on a Powerbook G4.
I noticed some unexpectedly small and large standard deviations coming
from a pivot table. I calculated these standard deviations with the
STDEV function and compared this with the pivot table. They are

I am trying to paste text from Word into Excel. I have copied the text
into a single cell, and am then breaking it apart and pasting into the
appropriate columns. At first this was working fine, but now it is
spreading the text across multiple columns, forcing me to use the

I found a time card setup described on another forum and have tried to
make it work for me. I have run into problems so I sent an email to the
original poster. The thing is, his post was from a couple of years ago
and I think his email may be no longer valid. Could you look over my

I don't know what vbCritical style is for.  I don't really want a style with
any buttons.  I just want a flag message that says the date of the report so
that the user knows if he happens to be on the wrong wksheet.
tnx,

The macro without the comments works, the problem is when I delete the first
row while testing I noticed if I run the macro a second time I get an error
since the row is already deleted.  Since the user could run it twice
accidentally,  I decided to put some error checking to ...

This sounds stupid, but I can no longer calculate in excel.  I was
fooling around with preferences, and while trying to solve one issue, I
started a new one.  This problem seems isolated to this one workbook,
but to all cells.  When I type in a formula, I just get the formula,

I tried putting "ands"  in between the lines to connect them between the if
and end if.
The compiler stops on  the delete line.
I need all three statements to work if there is a date on the first line.  

I'm working with two worksheets; one has the following columns: (1)
name of sponsor, (2) level of sponsor ($ amount), (3) number of passes
for that sponsor.   The data on this spreadsheet is updated each time a
new sponsor is obtained.    The second worksheet has the following

I have two files with the first column being an eight-digit identifier
that is formatted as General. However, the vlookup command won't work
because one of the files refuses to recognize the General cell
formatting no matter how many times I try to change it.

In Quark XPress 6.52 (6.5 also for that matter).
If one makes an image box and choose "Get Picture..." from the "File" menu
(Command + M) and then happen to select an Excel document wacky things start
to happen. If you have Excel open it will crash and then a little later so

Dear all. I would like to know if there's a way to page break after
each occurance of a specific column (change in field content) in a
pivot table (as you can choose to do so in a PC by choosing the Layout
option. Hopefully there is a way to do so, because it's great tool.

I use the current version of Microsoft Excel
for Mac OS X 10.4.7.
I am making some Pivot Tables but
missing the menue entry (I know from

I am trying to create a cost calculator form, which will automatically
calculate the discounted monthly price for a service based on the
number of units.    The discounts are:
if  units =<50  price = 10

Am I missing something?  Where is the subtract function for Excel?  I'm
trying to set up the family budget and can't find out how to enter a
function to find the difference between two numbers (as in money left
over after all the bills are paid).  I tried the insub function, but it