Is there a "simple" way to add up Stones, Pounds and Ounces? I have tried
using three columns, one for each then dividing the total of the Llbs by 14
and Ozs by 16 but cannot get the end figure to show correctly. i.e the final
figure may be shown thus: 36.625

I have this data that stored into several cells and each sell holds a
combined 20 data entries in one cell seperated by a space. I was
wondering is there anyway to extract that data with out having to rekey
the numbers. We are talking about a combined 2000 line items if

Greetings to the group.
Since yesterday I cannot open a file that I used everyday, due to a
"Not enough memory" error message. The problem is not on the computer
but on that particular file, because I can open all the other files,

aargh...All I want to do is rename an open sheet so that it reads English9
rather than Sheet 1....easy enough, one would think.  I right click on the
tab, type in the text.  First time I did this, it was renamed as
.xls]English9.  I tried again as I didn't like the .xls] in front ...

This is a re-post, in a sense, of a question I posted last week to this
forum.
I work at a college and use SUMPRODUCT formulas to total up all kinds of
stuff.  For example, to calculate the number of people majoring in a

I maintain a spreadsheet for a telephone hotline.  We track total
number of calls received (column F) as well as average time to answer
the call (column J).  To analyze the month's average time to answer, I
use the following weighted average formula:  SUMPRODUCT

I have a column of data I need to add with Excel. The data is available to
the public on the Internet as an HTML document (originally a .zip file). The
.html file is shown in Windows Explorer with a Windows Internet Explorer
symbol.

For a system I am making, I need a Macro that; copies the first word of the
content of a cell. These words have different lenghts.
For example.
I want the first word of A in Collum B

I am running Excel 2003 in Win XP Pro SP2
I would like to set up cells so the fill color:
= pale blue when the entered value is => 110
= no fill if =< 109

Is it possible to get a macro to take the Content of a cell and use that to
alter a pivot table.
For example:
"In the pivot table the different criteria for Page are 1;2;3. Usualy it

Is there a macro that I can take a work book that has 8 seperate worksheets
of data, and put all the data on one worksheet?. I need to sort all the data
on one sheet. Currently I cut and paste the data to the one sheet.
Any help would be appreciated.

I am designing a measurement spreadsheet with the
following conditions:
DESCRIPTION:
For a Project, every Milestone is linked to another

I'm having a problem with Excel 2000 when I am trying to insert a new row in
the middle of an existing worksheet.
I keep getting an error message that says:
"To prevent possible loss of data, Microsoft Excel cannot shift nonblack

I have very big problem. I have two formula to show and tell me the
difference:
Formula that doesn't work:
=SUM(IF(data!$F$2:$F$300="KP2B-PCB

In case of the Forms I use, it is Desirable to make them as compact as
possible. Stripped of any unnecessary items. It seems usefull to make a form
which ads a new textbox everytime something has been entered in the last one.
My question: "What Code should I use to get my forms to ...