Win XP, Office 2003
Insert>Symbols - only 1/4, 1/2 & 3/4 are available.
How do I get other fractions, e.g. 1/3, 5/8 or 7/16 to appear?

Is there any way to refer to the "previous" worksheet rather than
having to provide a specific name? This would obviously be dependent
on the order of the worksheets being numerically listed somewhere but
I have no idea if this is the case.

When I copy text from within an email body to Excel 97, it is always formatted differently from the Excel document,  that is, both wrapped text and merge cells are checked.  I would like it to remain unformatted - any way to do this without having to reformat the copied text ...

I am build a budget template which will have sever worksheets within the
workbook and each worksheet will be identical. The problem is that I have
hyperlink to directed toward different part of the template and every time I
create a new template by coping the skeleton template ...

Is there a way to extend solution(s) in thread "Stumped" to accomodate
a situation that follows:
A    B    C
Key    Input    Desired Solution

I have users who experiences MS Excel 2002 SP3 is shutting down very often...
It happens every time they do a "bold" command, when they try to save it
closes with an unknown error.
I checked the security patches, all are updated. Funny is when I do a "ran

I am currently using the following formula:
=SUMPRODUCT(--(ISNUMBER(FIND("SPGM",'7-14-07'!$E$2:$E$65535))),--
(ISNUMBER('7-14-07'!$Y$2:$Y$65535)),--('7-14-07'!$Y$2:$Y$65535<=$F$3))
this sumproduct matches product codes from work sheet 7-14-07 column

I want to find all key-value pairs if there is key with different value.
in the case above
A   1
A   1

I have numeric data in 4 different columns.  Each column has a different
label.  I want to compare the numbers in each column on a row by row basis
and have the column label of the lowest value inserted in a different column
at the end of the row.

I have read the answer to the Pivot Table Grouping issue sent in by Hrider
about a year ago. I have the same problem but the solution doesn't seem to
apply. Still when I try to group the datesI get an error "Cannot group this
selection".

A pretty simple question I guess. I am trying to make a template to do
material take offs for a construction company. I am trying to add 10-15% to
various cells. An example of what I am after.
        A   |     B     |      C

I am trying to find the sum of all values in the monthly worksheets (JAN:DEC)
that meet two conditions;  If A2:A7 on any worksheet=Dallas and B2:B7=AD, sum
the value in Col D.   Any help will be greatly appreciated!
Col              Col               Col

Most of my graphs have to be black and white and are best produced
with simple left or right diagonal line fills, dots, or the like.
In drawing bar charts in previous versions of Excel, one could always
click (focus?) on a a bar or series of bars and then click on

I have set up ledger sheets in Excel for our clients, recording balance
forwards from the manual system, then put in a formula to add payments and
subtract disbursements.  When I set up the formula, (i.e- SUM(b9-c10+d10),
the first line worked fine, then when I used the handle to ...

I've found a lot of posts about problems doing various actions across
worksheets but can't find any general information on this. Does anyone
know of a resource or could anyone provide a summary of what is and is
not possible to do across worksheets? Specifically: