Cell Validation for Decimals

[ringo]

How can I set the cell validation of a list of cells to have a
value(less than 4 Decimal place)?
Thanks.


Ringo Tan

 

[Max]

How can I set the cell validation of a list of cells to have a
value(less than 4 Decimal place)?

(Adapted from a previous post by Ron Rosenfeld)

Select the list of cells, say A1:A10

Click Data > Validation > Settings tab

Select "Custom" under Allow:

Put in the "Formula:" box:
=(A1*10^3)=INT(A1*10^3)

Click OK

 

[Norman Harker]

Hi Ringo!

Try:

Data > Validation
Allow: Decimal
Data: Less than or equal to
Maximum: 0.0000999999999999999

(there's 15 nines there)