prevent users from entering text valuesin data region of input schedule

Hello,

When users send data & by mistake a data input cell is written with text , then the original value of the cell becomes a zero.

Is there any way , i can prevent this techincally.

Some options are excel data validation which is not fool proof as text can still be be copy pasted..

The next option is a macro which is cumbersome, as i have to specifically check for individual range of cells rather than the entire sheet.

Is there a way , that BPC can automatically deny a text value /or makes no change when text is entered to data input cell?

thanks.,

sridhar