I'm having a problem with the LOOKUP function ... it's referencing incorrect
rows!  Here's my test Data
I'm in WORKSHEET2 (cell A1).  Here's the other worksheet:
[WORKSHEET1]

How do I set up a formula that will write a zero to a range of cells?
I wish to click on a radio button or such to effect this action.

I have data in an Excel XP 2003 spreadsheet that I need in invoices.  Will
Excel generate these invoices for me?  How do I set that up?  

I need to look up values in a tabel that has subtables.
Example:  
35376    WEEK     22
    MONTH   33

How can I convert a 2 rows of titles and corresponding numbers into 2
columns?
Rebecca

I am creating a shared work book and want fifferent users to update only
parts of the shared work dook

OK... here's the question.  I have a cell that I input a number into.  If I
input a number less than 1, I want the cell to be formated with a percentage
sign.  If I input a number greater than 1, I want it to show just as a number
(with no percentage sign).  

1.  I have a workbook with data that is linked from other workbooks.  In this
final one I have linked the color score (e.g. RED, BLUE, GREEN, YELLOW) which
appears with a background of white.  I need the background to appear in the
color that is linked but conditional formatting ...

I have a text field with a '('.  
ex: 125 108(130
I want to replace the '(' with a '/' without changing the format of the
field to a fraction so my result would be '125 108/130' instead of changing

when creating an invoice, i want my total to appear in number format and in
text
how can i do that

Our company uses counties to determine sales territories, so I often need to
take a database of addresses and ad a column for the county, and then
manually populate the cells.  I then use a pivot table to divide the
information up into sales territories.  Is there a way to have ...

In using a regular spreadsheet, that is not protected in Excel 2000, if an
error is made entering a value, formula etc in a cell, the Undo feature is
unavailable to reverse the entry. Why and how do I change it to have it
"reactivated"?

I have data in a spreadsheet in excess of 65536 lines so I have the data on
more than one page in a workbook.  How do I create a pivot table that will
use more than one page of data to create the pivot table?  Is it possible?

I have over 1000 small parts and need some sort of control showing when parts
are runing out and need to be reordered.

Hi,
Im updating an excel sheet to incorporate some business changes.  The
problem is, i can edit the sheet and the code, but i cannot edit the dialog
boxes. Can someone explain how to bring up a dialog box explorer? or editor?