Column Validation for Sort Code and Account Number in SharePoint Column validation provides a solution to validate data for data integrity. This post covers column validation for Sort Code and Account Number in SharePoint. Validation for Sort Code =AND(LEN([Sort Code])=6,ISNUMBER([Sort Code]+0)) The above formula checks The length of the sort code must be exactly 6 digits. The sort code must be a number. Validation for Account Number =AND(LEN([Account Number])=8,ISNUMBER([Account Number]+0))