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

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.

"carrera0000" wrote:

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

=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



--
Regards,

Peo Sjoblom



"carrera0000" wrote in message
...
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

Thanks!

"Peo Sjoblom" wrote:

=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



--
Regards,

Peo Sjoblom



"carrera0000" wrote in message
...
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