I have experienced a problem that I am unable to find a rectification
for. When my staff constantly use the space bar to delete an entered in
error number and leave the cell blank (although there is a space in the
cell) any cell which uses that cell within its formulation shows
#Value! or #####. I am aware that they should not be using the space
bar to delete numbers and the space within the cell is the reason for
the other formulation errors. I guess my question is how do I format
the cell so that only a number and nothing else can be entered?


--
Field8585
------------------------------------------------------------------------
Field8585's Profile: http://www.excelforum.com/member.php...o&userid=31282
View this thread: http://www.excelforum.com/showthread...hreadid=509519