If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.
If you see the error “This value doesn’t match the data validation restrictions defined for this cell” when entering a value in an Excel cell, the solutions ...