Canadian Postal Code

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

?Validate Canadian Postal Code 5
Column All Upper Case 14
Verify Canadian Postal Code ~ make the code work 2
Multiple Input Masks? 1
postal codes 1
Postal Code 3
Postal Code 11
Canadian Postal Code format? 9

Back
Top