Corrupting a Cell
 

Is there a way to prohibit a user from using a space bar in a cell or from using the delete key to erase a value. Have managers that fill out a log sheet each day, at the beginning of the next day they clear the old information using the space bar or the delete key and it messes up the totals at the end of the form. I want restrict the cell to accept only a decimal value number.

Corrupting a Cell
 

Hi
have a look at 'Data - Validation'. See:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Stumpy" schrieb im Newsbeitrag
...
Is there a way to prohibit a user from using a space bar in a cell or
from using the delete key to erase a value. Have managers that fill
out a log sheet each day, at the beginning of the next day they clear
the old information using the space bar or the delete key and it messes
up the totals at the end of the form. I want restrict the cell to
accept only a decimal value number.

Corrupting a Cell
 

Data Validation?

http://www.uncc.edu/sysdev/HowTos/Ex...In%20Excel.htm

Judy Freed
Systems Development
UNC Charlotte


"Stumpy" wrote in message
...
Is there a way to prohibit a user from using a space bar in a cell or from
using the delete key to erase a value. Have managers that fill out a log
sheet each day, at the beginning of the next day they clear the old
information using the space bar or the delete key and it messes up the
totals at the end of the form. I want restrict the cell to accept only a
decimal value number.

Corrupting a Cell
 

Hi

You can do that with the Data Validation meny. Define the acceptable
number type, its border values, and uncheck "ignore blanks"

HTH. Best wishes Harald

"Stumpy" skrev i melding
...
Is there a way to prohibit a user from using a space bar in a cell or from
using the delete key to erase a value. Have managers that fill out a log
sheet each day, at the beginning of the next day they clear the old
information using the space bar or the delete key and it messes up the
totals at the end of the form. I want restrict the cell to accept only a
decimal value number.