Posted to microsoft.public.excel.misc
|
|
Cdn Postal Code
Thank you both!
"Bernard Liengme" wrote:
Excel lets you make formats for numbers but not masks for text
Only thing I can suggest is using formula =UPPER(LEFT(A1,3)&" "&RIGHT(A1,3))
to do the conversion
Later you could use Copy followed by Paste Special Values to convert that
column to text. This allows you to delete the input column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Christine" wrote in message
...
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!
|