Customize Cell

[kcgojnur]

Hello -

Is there a way to customize a column of cells that requires 9 digits (no more or less) and no dashes? This column will be used to enter social security numbers. I was able to customize no dashes, however, not sure how to require 9 digits in addition to no dashes.

 

[JoeMo]

Have you tried it?

Hadn't tried it when I posted as I was not near my computer. As soon as I posted it I realized that the INDIRECT is needed if the DV is to be applied to more than a single cell, but I got called away and just now returned.

 

[Peter_SSs]

.. I realized that the INDIRECT is needed if the DV is to be applied to more than a single cell,..

INDIRECT is required anyway (at least in my opinion) otherwise, if rows are added/removed above the DV cell(s), instead of having 48:57 you could suddenly end up with, say, 50:59 which would no longer just be dealing with digit codes.
As far as I have been able to come up with the SUM(9-LEN(....))= 9 is also required.

 

[JoeMo]

INDIRECT is required anyway (at least in my opinion) otherwise, if rows are added/removed above the DV cell(s), instead of having 48:57 you could suddenly end up with, say, 50:59 which would no longer just be dealing with digit codes.
As far as I have been able to come up with the SUM(9-LEN(....))= 9 is also required.

Yes, certainly seems that way after testing it a bit. That's a very creative solution!

 

[Peter_SSs]

Thanks Peter, worked perfectly!

Sorry, I didn't mean to ignore this post earlier .. you are very welcome.


.. and thanks Joe, but I didn't create that all on my own - adapted an idea I saw somewhere else.