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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to create charts 1
Change "Text Like" to "Greater than" 3
Formatting short times 2
Need to insert RS in the formula 0
Calculating occupational sick pay entitlement 0
transpose and concatenate 3
Receiving valid Multicast address failed on mini port driver 0
VBA Validation between two Times 17

Back
Top