Hi,
I have a data in the cell with
minValue=0
maxValue=1
Formatstrinf ="0.00"
Maskinput="n.nn"
While editing the cell , it is allwoing the value greater than 1(i.e maxvalue) like , if I entter a value 1.234
cell is taking the value even it is greater than 1
How to restrict the cell value not to accept more than max value
Hello Ishnant,
I tried your scenario and it seems to work fine. Is your column's datatype of decimal? Please take a look at my sample and let me know if I misunderstood you or if you have any other enquiries.
Hi Boris,
my cell datatype is Decimal.
but when I type in the cell it allows the value greater than maxvalue (1.22).
When I have 1in the firat place , cell should not allow us to enter 1.23, or whar ever the value after 1 because cell maximin value is 1.
and also when I edit the cell i am getitng underscore also(in the same example you sent me)(1._0).
Please I need to remove the underscore and restrict the user entering more than maxvalue