| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Canadian Postal Code
There is a US zip code in the format list but does anyone
know how to format for a Canadian Postal Code ie; A1B 2C3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Canadian Postal Code
No.. As opposed to US codes the Canadian codes are text and you can't format
text. If it is the caps and the space that bother you then you could use an event macro or a help column with formula that would do that for you -- Regards, Peo Sjoblom "Tim" wrote in message ... There is a US zip code in the format list but does anyone know how to format for a Canadian Postal Code ie; A1B 2C3 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Canadian Postal Code
http://www.canadapost.ca/personal/to...b03-e.asp#c014
tim. "Tim" wrote in message ... There is a US zip code in the format list but does anyone know how to format for a Canadian Postal Code ie; A1B 2C3 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Canadian Postal Code
Tim,
what is the specific format problem you're having? Are they displayed incorrectly (ie. a1b 2c3 or A1B2C3). If you have more info I might be able to help you. Dan E "Tim" wrote in message ... There is a US zip code in the format list but does anyone know how to format for a Canadian Postal Code ie; A1B 2C3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format for Canadian postal codes | Excel Discussion (Misc queries) | |||
| Canadian Postal Code format? | Excel Worksheet Functions | |||
| formula for Canadian postal codes | Excel Worksheet Functions | |||
| formula for Canadian Postal Codes | Excel Worksheet Functions | |||
| Using excel 2003 cannot see Canadian Postal Codes | Excel Worksheet Functions | |||
Hybrid Mode
