View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fritz Fritz is offline
external usenet poster
 
Posts: 29
Default Canadian Postal Code format?

I would like to type is our Canadian Postal Code and have a special format
that forces the right entry. Our Postal Code consists of
3 characcters a space and 3 more character. Ie "S0L 1G9".
It is always a "UPPERCASE LETTER, number, UPPERCASE LETTER, space, number,
UPPERCASE LETTER, number".

I would like to enter it in lower case but have it converted to upper case.
Is this possible. Thanks