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.