Customized Formats
How do I build a customized format for the Canadian postal code?
Example: T2R 1N1 (Contains both text and numbers) |
Not possible unless the text part are all the same which I assume they are
not, so either straight text or some sort of macro solution. Are you looking to avoid typing a space or just using lower case, what is the purpose of wanting a custom format? Regards, Peo Sjoblom "ABgal" wrote: How do I build a customized format for the Canadian postal code? Example: T2R 1N1 (Contains both text and numbers) |
All times are GMT +1. The time now is 06:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com