Welcome Guest.

3Answers

Great God, ask an EXCEL question. Add a dot in the middle of the number. There is “”-” in the original number.

Asked by: Henry Harrison 239 views IT December 20, 2018

20180203-20181213 A column is changed to 2018.02.03-2018.12.13

If there is no intermediate ""-"" direct change, you can change it with 0000\.00\.00. Help God to enlighten me

Thank you very much

3 Answers

  1. +7Votes  

    =REPLACE(REPLACE(REPLACE(RE1(13),"."),7,,"."),5,,". ")

    Rebecca- December 20, 2018 |

  2. +7Votes  

    =TEXT(SUBSTITUTE(LEFT(A1,16),"-",),"0000!.00!.00-0000 !.00!.0")&RIGHT(A1)

    Jerry Thompson- December 21, 2018 |

  3. +7Votes  

    Figure effect:

    B1 setting formula:

    =LEFT(A1,4) &"."&MID(A1,5,2)&"."&MID(A1,7,2)&MID(A1,9,5)&"."&MID(A1,14,2)&". "&MID(A1,16,2)

    Robert Hill- December 21, 2018 |