Need help with data validation format - please !

  • Thread starter Thread starter Sulthon_NiShang
  • Start date Start date
S

Sulthon_NiShang

I'm trying to make this format mandatory when someone enters his/her
data in a cell.

The format would be this : "### ###". Therefor, if the worksheet user
doesn't enter a chain like this one : "113 244", the data just won't
enter. And yes, the space beetween the 3 first and last numbers has to
be there.

I can't seem to find anything in the Data / Validation menu that
enables me to do this :confused:.

Any help would be much appreciated. Thanks in advance.
 
This may not be the best workaround, but it seems to work!


Highlight the cells that require this 6-digit formatting. Click on
Format, Cells. Then click on Custom.

Enter ### ###

This means that even if a user types in 123456 it will still come out
as 123 456.

Now, with the cells still highlighted, click on Data, Validation.
Select 'Text Length', Equal To, and type in 6.

Dan.
 
Back
Top