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?
Bookmarks