How do I set up data validation for Bank sort coes
 

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??????

How do I set up data validation for Bank sort coes
 

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" wrote:

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??????

How do I set up data validation for Bank sort coes
 

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

"Gary76" wrote:

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" wrote:

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??????

How do I set up data validation for Bank sort coes
 

Would

Minimum: 100000

Do the trick?

HTH
"Chris" wrote:

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

"Gary76" wrote:

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" wrote:

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??????