Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format
I would like to use a custom format that will take a number/text string like:
1405828AB And convert it to: 140N-58W-28-AB Where the N and W are fixed, but the "AB" can be any combination of two of the following four letters A, B, C, D. I have a version that works for everything but the letters at the end and it is: ###"N"-##"W"-##- but can't get the rest of it. Your help is greatly appreciated... Thanks, J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
General Format to Custom format problem | Excel Discussion (Misc queries) | |||
ignore auto format after applying a custom format?? | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions |