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?