Hi Sandy
A space followed by ENTER is not a valid entry. It is a text (CHAR(32))
so the data validation does not accept it. If you want to remove the
entry just select the cell and hit DEL. This will clear the content
Frank

Sandy wrote:
Still doesnt work like I want it to....User enters a number and later
wants to remove it. Space bar followed by enter bar gives error.
Retry plus enter user can enter another number but doesnt clear, and
cancel defaults back to previous number that was entered. Am I
really that blonde???? Thanks