Hi,  I made a spreadsheet of addresses with the rows formatted across as:
name, address, city, state, zip.  
name2,address2,city2,state2,zip2
However, now I would like to change the format to

Hopefully there is a simple answer to this.  I have cells formatted as
general, though I have tried it text too, and would like to enter in a +
or -.  Everytime I do it, it assumes I'm entering in a function and changes
it to +D2 (id I'm in the d2 cell.)  How can I put in a + or - ...

I just bought Microsoft Office Student/Teacher edition.  I was using
Microsoft Works.  My word processing documents all converted, but I can't get
my database to convert.  My spreadsheets converted also.
Help

I have a macro that is executed by clicking on Tools/PrintSheet on the Menu
Bar for a particular workbook.  I'm trying to change the name for PrintSheet
to something else, but the change always go back to the way it was, when I
open the workbook again.  I'm using Excel 2002

Does anyone know how to show the Gridlines through a fill? I've searched and
searched but can't find the answer, yet the silly thing is I know it can be
done as I have done it before (by accident)
Any help mostgratefully received!

On behalf of my newphew, I received this query:
"Quick one - I have a spreadsheet with very long formulas that reference a
whole lot of variables in the same column. I tried naming the cells so that
writing of the formula is easier to do. However, I need to copy the column

Column C either contains Item ID numbers or on some rows is merged across to
Col. F to contain a text label.  I need to ensure a Group ID is in Col. B if
an Item ID is in Col. C.  I can't use "blank", because it picks up the text
label.  What is the best way to assign a data ...

Can somebody please advise me on how to do the following in Excel:
Compare a set of values (text) in column A with a set of values (text) in
column B (no necessarily in line with each other) and output any differences
to any of the following:

i am a relatively new user of VBA. i want the list of control ids
available in a workbook so that i can use them in VBA code
can anybody please help
Regards

I want to create a range of results in one worksheet based on a range
of input values in another worksheet in the same workbook. I've
'named' the input and result ranges in Excel but am unable to clear
the result range using the following code called from Excel with

I have an Excel file on a floppy that was created in the year 2000 on a (now
deceased)
computer with WIN98 and Office 2000. I just tried to open it on my Panasonic
Toughbook with WIN98, also Office 2000. The Excel refuses to open it, saying

I need to check that data entered into a document is correct,
I have loaded a spreadsheet from the text file and saved it as a xls file.
Column B and D are supposed to show the same data
but errors have been made, is there some way to have Excel compare column B

How do I formulate the following in Excel.
A1     A2                      A3
45      55              {(45+55)}*30%
                                 = 30

I've had a macro in place, that permitted me to
print a group of columns.
Over a period of time, comments were added to my spread sheet (the little
red triangles in the corner)

I have a column with a list C1 to C2000,
it is jumbled up, I want to sort it numerically from
C1,
C2 etc