R
Ron
How do I format cells in the Canadian postal code format?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fred Smith
What's to format? Simply treat it as text.
D
David McRitchie
By typing the space.
--
--
G
Gord Dibben
Canadian Postal Codes are Text and cannot be formatted as US Zips can be.
Assuming your postal code is in A1, in a seperate column enter this formula:
=LEFT(A1,3)&" "&RIGHT(A1,3)
You can then Copy and Paste Special>Values over the original data.
Gord Dibben Excel MVP
Assuming your postal code is in A1, in a seperate column enter this formula:
=LEFT(A1,3)&" "&RIGHT(A1,3)
You can then Copy and Paste Special>Values over the original data.
Gord Dibben Excel MVP
D
Debra Dalgleish
And just to be safe: =UPPER(LEFT(A1,3)&" "&RIGHT(A1,3))