With your data in column A, in another column try
=LEFT(A1,2)&"-"&RIGHT(A1,LEN(A1)-2)
Copy and Paste Special, Values the new column to lose the formulas, then cut
and paste the new column to overwrite the original,
Try this out on a copy of your original worksheet!
Regards,
Alan.
"Deb" wrote in message
...
I have a column of numbers and I need to add a dash between the first two
numbers without having to do it manually (several thousand rows). Is it
possible?