Limit text length to the 4th decimal place

  • Thread starter Thread starter roxyr
  • Start date Start date
R

roxyr

I'm assuming this is fairly easy one (not for me however)

Is there any way I can format a cell so that the maximum number o
characters allowed does not exceed 4 decimal places?
I know how to use the validation text length feature, but it does no
seem to work for decimal places.

Help
 
I'm assuming this is fairly easy one (not for me however)

Is there any way I can format a cell so that the maximum number of
characters allowed does not exceed 4 decimal places?
I know how to use the validation text length feature, but it does not
seem to work for decimal places.

Help!


---
Click to expand...


If the cell is J1, you could use the formula in Data Validation:

=(J1*10^4)=INT(J1*10^4)




--ron
 
Back
Top