I'm creating a spreadsheet for work, and I would like to use one multiplier
throughtout the entire spreadsheet, instead of having to enter repeatedly
putting in the same forumula over and over again..  the cells contain
different numbers but the multiplier will always be the same ...

The Vista/Excel 2007 multiplication bug makes one think ... and play a
little with the WinXP/Excel 2003 too.
Try this (best is column-wise for systematic checking):
METHOD

My excel worksheet is Formatted to 'General', but when I try to type
in a number, it automatically moves the decimal 2 places (e.g. I type
"34" and excel reads "0.34" or I type "156" and excel read "1.56") The
problem still occurs when I format the cells to "Number - 0 Decimal"

I have created a worksheet and put in a formula to add together 4 cells.
the resulting total is 1p less than when I add it together manually.
How can this be?

I need to combine the results of two worksheets that are in one
workbook for an execption report.  I use the filter comand to filter

Copying and pasting is an option, but if the sort order changes, there

I have data consisting of New Traffic and Returning Traffic.  I need to find
out the percentage of New Traffic that is Returning Traffic.  What formula do
I use?  Help!!!

I am trying to compute in Excel 2007, the length of service of employees.
While I have been able to computer the years, I would like to see the number
of months and days rather than a fraction of the year.

I would like to cut the first character in each cell of column B.
-Example the cell may contain 6008, I would like to change that to
008. Also, cell may contain G302; this should be just 302.
Is there a function or macro that i can use to do this?

I currently log costs for our clients into an excel database. Each
client has their own worksheet which contains the following columns:
Date (A) - Postage (B) - Copies (C) - Fax (D) - Phone (E)
I am given cost sheets to input into the database that are not in

I need a macro that selects specific sheets, goes to FILE, then PRINT.
and stops there. THe user will choose the printer.
The macro editor won't allow me to stop recording once I've chosen
print.

What's popular as the next step after j-w's (et al) books? I'm
thinking C calls, WIN API, SQL interface, ODBC, interfaces with other
applications - notably the web - etc.? Ideally (which I suppose is the
grail in authoring) these would start from mere familiarity with those

I have a pivot table that I use to list invoices paid on a certain date.  I
fill in this field in the spreadsheet, refresh the pivot table and select the
date I want from the dropdown list but it doesn't always list all the
invoices.  Then I'll refresh it again and it displays an ...

We used to store excel data to a CSV file on our server to be pickup by
another program.  This is always done with a macro which simply executes a
save-to-csv.
Since installing Office2007, this macro writes this CSV file with a wrong

I have the following in Col A:
18-35-DPL
RR-9-19
In Col B, I want a formula that returns "Yes" if the cell in Col A contains

I'm making several spreadsheet showing month cashflow data that rolls up
from pivot table on another sheet.  I've been selecting the cell I want the
data to go to, entering "+", then selecting the pivot table cell I want to
get the data from.  This works great and pops the ...