G Guest Aug 4, 2004 #1 How can I set the cell validation of a list of cells to have a value(less than 4 Decimal place)? Thanks. Ringo Tan
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 Aug 4, 2004 #2 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
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 Aug 4, 2004 #3 Hi Ringo! Try: Data > Validation Allow: Decimal Data: Less than or equal to Maximum: 0.0000999999999999999 (there's 15 nines there)
Hi Ringo! Try: Data > Validation Allow: Decimal Data: Less than or equal to Maximum: 0.0000999999999999999 (there's 15 nines there)
