Marcin, On Thu, 2020-05-21 at 13:30 +0000, Marcin Wyrwalski wrote: > Hello. > > I would like to ask, if there is a possibility to set up constraint to not > allow user to write more than three decimall places in cell? I preparing and > sending file to user, and user is supposed to return file with some data.
The closest thing I found look like that: https://exceljet.net/formula/data-validation-number-multiple-100 (Validity defined by a formula.) You will likely compare ROUND(x, 2) vs ROUND(x/100) and test for Zero or something like that. Cheers Andreas