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