Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Customized Formats
How do I build a customized format for the Canadian postal code?
Example: T2R 1N1 (Contains both text and numbers) |
#2
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
removing customized toolbars | Excel Discussion (Misc queries) | |||
Copy with link between sheets - all the formats dissapear?!? | Excel Discussion (Misc queries) | |||
Too Many Different Cell Formats | Excel Worksheet Functions |