| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format for Canadian postal codes | Excel Discussion (Misc queries) | |||
| formula for Canadian postal codes | Excel Worksheet Functions | |||
| formula for Canadian Postal Codes | Excel Worksheet Functions | |||
| Validation of Postal Code | Excel Worksheet Functions | |||
| Using excel 2003 cannot see Canadian Postal Codes | Excel Worksheet Functions | |||
Threaded Mode
