Cell Validation for Decimals

R

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
 
M

Max

ringo said:
How can I set the cell validation of a list of cells to have a
value(less than 4 Decimal place)?
Click to expand...

(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
 
N

Norman Harker

Hi Ringo!

Try:

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

(there's 15 nines there)
 
Top