Hello Folks,
I have been creating an enquiry form for use by our Sales Teams but I have problem in that I can not format a cell in the UK Postcode format.
The format would be 2 capital letters/1 or 2 numbers/space 1 or 2 numbers/2 capital letters.
Does anyone know if this can be done?
I have seen several VB Codes which will change the format after it has been entered, but I want to force the users to enter the Text in the correct format to begin with.
Thanks
I have been creating an enquiry form for use by our Sales Teams but I have problem in that I can not format a cell in the UK Postcode format.
The format would be 2 capital letters/1 or 2 numbers/space 1 or 2 numbers/2 capital letters.
Does anyone know if this can be done?
I have seen several VB Codes which will change the format after it has been entered, but I want to force the users to enter the Text in the correct format to begin with.
Thanks