| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cdn Postal Code
How do I creat an input mask for the the Canadian postal code?
I would really like the person the be able to type v2v2v2 and have it formatted V2V 2V2. I can do this in Access so I was hoping I could do it in Excel. It's either an input mask or formatting - I really don't know the proper terminology. Normally, I would use Access for this particular task but the person I'm creating this for doesn't have the software. Sorry if this is a repeated question but I just don't use Excel too often. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Canadian Postal Code format? | Excel Worksheet Functions | |||
| losing the leading zero when merging zip+4 postal code | Excel Discussion (Misc queries) | |||
| How do I retain a zero as the first number in a postal code? | Excel Discussion (Misc queries) | |||
| How can I get a postal code in a cell - from the internet? | Excel Worksheet Functions | |||
| Validation of Postal Code | Excel Worksheet Functions | |||
Threaded Mode
