Corrupting a Cell

[Guest]

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.

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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.

 

[Judy Freed]

Data Validation?

http://www.uncc.edu/sysdev/HowTos/Excel/Using Data Validation In Excel.htm

Judy Freed
Systems Development
UNC Charlotte

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.

 

[Harald Staff]

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

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.