Limit text length to the 4th decimal place

[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

 

[Max]

Try ..

Say, for A1

In DV settings tab

 

[roxyr]

Works perfectly.

Cheers

 

[Max]

You're welcome !
Thanks for the feedback

 

[Ron Rosenfeld]

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!


---

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

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




--ron