insert it in a column to the right (assume a new column B)
=Left(A1,6) & "-" & mid(A1,7,255)
then drag fill all the way down.

now select the column and do Edit=copy, then Edit=Paste Special and select
values.

Now delete the original column.

So I guess you are the nerd that needs to do it.

--
Regards,
Tom Ogilvy



"spreadsheet monkey" wrote:

I need a solution/macro to insert a minussign (-) into a 10 digit number
between digit 6 and 7 (to get a number looking like this xxxxxx-xxxx)

I need to do it in a single column for all 65 536 lines of code in the
spreadsheet.

who of you is nerd enough to tackle this challenge?