I have a column of eleven non-sequent cells that may or may not contain a
currency value.
I need to copy this information across to another column of sequent cells,
but I only wish to copy the cells that contain a value. Cells that are blank

How would I go about changing or writing the formula:  ='1'!$H$19+'1'!$H$57
so that the next rows are
='2'!$H$19+'2'!$H$57
='3'!$H$19+'3'!$H$57

I have a simple spreadsheet that keeps track of items requested of one of
our suppliers.
Works fairly well, it does a few calculations but is mostly just to keep
track.

I have copied and pasted a word table into excel which was a pain in
itself.  The date format in word was Thu 21st June 2007.  But the
table would not sort into date order so I had to remove the "Thu"
part.  I then had to remove the paragraph sign as it was throwing

The numbers keyboard on my desktop will not function.  When using it in an
Excel worksheet, instead of entering the number the computer moves the cursor
to the previous cell up.

I work in a office with several other people and we have a spreed sheet or
work book I guess you would call it that we all would like to use at the same
time. Is there a way to remove the read only if some one else has it open?
Thanks

I would like to ask if anyone thinks this is a bug w/ Excel 2007.
I did not catch a problem recently because I relied on "ShowPrecedents."
The code below will set the problem up.
Cell A2 correctly shows that there are two cell ranges.

Figuring out how to word this question is probably harder than the question
itself.
OK, I have a spreadsheet that will probably be used for years so it can get
longer and longer as time goes on.

Can anyone advise please if it is possible to display one Excel
spreadsheet on one monitor and a second Excel spreadsheet on a second
monitor at the same time, and if so, how to go about doing so?
Thanks in advance for any help anyone can provide.

Using Excel 2003.
I am using dates with the format .... yyyy/mm/dd in a Genealogy worksheet.
When I input dates in the 1900 range I get all sorts of problems  ....
showing as ########### because they do not fit into the column width as 1899

How do I get, and add, formulas to an existing spreadsheet that will allow me
to show a 10% yearly increase? I couldn't find the right combination.
Thanks,
Ray

How would I format a cell in Excel 2003 that will show any IP address as four
groups of three numbers separated by periods?
For example, I would want 123.98.0.876 to appear as 123.098.000.876.  The
most extreme example being that I would want 1.1.1.1 to show as

Can I show the date, time and day of week in one cell.
I have:
09/03/07 8:30 AM
in one cell using the format (Format/Cells/Custom):

Not having a great deal of experience with macros, I thought I might
see if I could pick the brains of the group.
I have to essentially break out a comma separated text string in a
single cell into a vertical list, with a reference number thrown in

I have a invoice I would like it to go to the next number the next time I
bring it up and do another invoice.