Debra and Muhammed,

Yes they worked, it was an operator error on my side.

Thanks much.

"el zorro" wrote:


I've used Data Validation on cell B1 (allow=custom/formula =A10) for my
application to allow entry on B1, however I also need to ensure the allowed
data entry on B1 is a decimal value.

Is there something I can add in the data validation to ensure a decimal
value entry?

Pls help.