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