| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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?????? |
|
#2
|
|||
|
|||
|
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?????? |
|
#3
|
|||
|
|||
|
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?????? |
|
#4
|
|||
|
|||
|
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?????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
| Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Linear Mode
