Sean,
Try this, select all the cells on the sheet by pressing the button to the
left of the 'A' column heading and above the '1' row heading. Go to
Format|Cells|Protection Tab and un-tick the Locked box. then select the two
cells you want to lock and repeated the above process but re-tick the locked
tab. Then go to Tools|Protection|Protect Sheet and press OK. Now you will not
be able to alter the two cells you have protected.

To make 300 USB appear in a cell when you enter 3 each in other use this
formula in the cell where you want the 300 USB to appera;

=IF(A2="3 EACH","300 USB",""), where A2 is the cell that you will enter 3
EACH.

"Sean DeBruler" wrote:

Please help!

I would like to be able to have have a cell formated with held text see
examples of cell A and B. I would like this text to allways be here even
when I delete.

A B
PLEASE ENTER QUANTITY HERE TOTAL USD

I would also like the following to show when I would enter the following in
to the above cells

A B
3 EACH 300 USD

Can this be done?