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

R

Robert_DubYa

=LEFT(A1,4)&"-"&MID(A1,5,3)&"-"&RIGHT(A1,4)

the above is if A1 contains your value.
 
P

Peo Sjoblom

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
 

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
Cannot Put A Border Around Numbered Text. What To Do? 0
Extract numbers from a string of text 0
Need to change numbers with dashes to numbers with no dashes 3
filtering for numbers ending in 000 3
how to extract 20 000 lines out of 200 000 lines automatically? 4

Top