If I have a list of numbers, how do I insert a dash in each one?

R

rayofsunshine969

If I have a list of numbers, 11 characters long, example: 00229603210, and
for each number I want a dash behind every 2nd, 6th and 9th number,
00-2296-032-10. Is there an easy way to do this?
 

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

Eliminating the dashes 3
formatted to place dashes within numbers formatted as text 1
how do i delete dash in phone numbers 3
Extract number between a dash 3
ADDING DASHES WITHIN NUMBERS IN A COLUMN 2
Format Text 6
Why do the preceding zeros disappear when I remove dashes? 3
How do I format a social security number to have no dashes? 5

Top