View Single Post
  #1   Report Post  
SarahAshlee SarahAshlee is offline
Junior Member
 
Posts: 3
Default Need help with a formula...

I need a formula that will allow a set of numbers to go from this:

xxxxxxxxxxxxxxx

to this:

xxxxx-xxxx-xxxx-xx


Every formula I've come across will only let me add three hyphens to a set of numbers, where as, I need to add four. I really don't want to have to do this manually. The hyphens in the example are placed where I actually need them to be.

Can anyone help?!