Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format
How to format something like 744532451500 into 74-45-32-45-15-00
this so the "-" are added automaticlly Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format
"Dreamstar_1961" wrote: How to format something like 744532ba1500 into 74-45-32-ba-15-00 this so the "-" are added automaticlly Forgot that the text is required in the middle Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format
XL can change teh format on numbers but it can not reformat text as you have
indicated. To do that you will need to use a formual in an adjacent cell something like this... =LEFT(A1, 2) & "-" & MID(A1, 3, 2) & "-" & MID(A1, 5, 2) & "-" & MID(A1, 7, 2) & "-" & MID(A1, 9, 2) & "-" & MID(A1, 11, 2) -- HTH... Jim Thomlinson "Dreamstar_1961" wrote: "Dreamstar_1961" wrote: How to format something like 744532ba1500 into 74-45-32-ba-15-00 this so the "-" are added automaticlly Forgot that the text is required in the middle Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format
Assuming that all the strings have the same number of characters (i.e. 12), a
formula like the one below will work. =LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&MID(A1,5,2)&"-"&MID(A1,7,2)&"-"&MID(A1,9,2)&"-"&RIGHT(A1,2) HTH, Eric "Dreamstar_1961" wrote: "Dreamstar_1961" wrote: How to format something like 744532ba1500 into 74-45-32-ba-15-00 this so the "-" are added automaticlly Forgot that the text is required in the middle Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
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) |