how to put dashes in a number 13000000000 to 1300-000-0000

  • Thread starter Thread starter Guest
  • Start date Start date
=LEFT(A1,4)&"-"&MID(A1,5,3)&"-"&RIGHT(A1,4)

the above is if A1 contains your value.
 
Use a custom format of

0000-000-0000

if you need it as text, use a help column and a formula like

=TEXT(A2,"0000-000-0000")

copy down/across, then select all formula and copy and paste special as
values in place
 
You must log in or register to reply here.

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

(social security number) 000-00-0000 to 000000000 1
Phone number format from 000.000.0000 to (000)000-0000 4
Cell Formatting Removing Dashes 2
Converting Phone Numbers 4
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
Unformating social security numbers 4
Can't figure this out 1
Find cell containing a letter 5

Back
Top