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