Copy & Paste Issue

[Guest]

I want to copy and paste a row of numbers but want to cut off the last couple
of digits and then format a certain way. Is this possible?

example: 123456789 copy and paste to new row as 123-456

 

[Guest]

The easiest way is to create a formula like the one below. the copy the
formula down the entire row.

=LEFT(D13,3)&"-"&MID(D13,4,3)

You can convert the formula to text by copy the range of cells and using
paste special with values checked.

 

[Peo Sjoblom]

=TEXT(LEFT(A1,6),"000-000")

if you want these as real numbers use

=--LEFT(A1,6)


and use a custom format of 000-000

 

[Guest]

Thanks!

=TEXT(LEFT(A1,6),"000-000")

if you want these as real numbers use

=--LEFT(A1,6)


and use a custom format of 000-000