Inserting "-" dashes into number

  • Thread starter Thread starter Lisa W
  • Start date Start date
L

Lisa W

I have a number that is always this format: 1993200000002000-02
and I need it to be this format: 199-32-0-00-00-002-00-0-02

Is there an easy formula to make this so?

Thanks, Lisa
 
Here is one way to do it...

=TEXT(LEFT(A1,10),"000-00-0-00-00-")&TEXT(SUBSTITUTE(RIGHT(A1,9),"-",""),"000-00-0-00")
 
Back
Top