How do I set up data validation for Bank sort coes

[Chris]

I am tring to setup data validation for bank sort codes, which are 6 ch., but
I want it as whole numbers only. Is there any way I can do that??????

 

[Gary76]

May have missed the point here but...

Something along the lines of:

Data > Validation > Settings

Allow: Whole number
Date: between
Minimum: 0
Maximum: 999999

Then Format > Cells > Number > Custom
Type: 00-00-00

HTH

 

[Chris]

Thanks, but the bank sort codes are fixed 6 characters, how do I do that
please.

 

[Gary76]

Would

Minimum: 100000

Do the trick?

HTH

Thanks, but the bank sort codes are fixed 6 characters, how do I do that
please.