sub AddX()
for i=1 to cells(rows.count,"a").end(xlup).row
cells(i,"a").value=cells(i,"a")&"-"& i
next i
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ultrarev" wrote in message
...
010630412
010630412
010630412
010630412
010630412
010630412
010630512
010630512
010630512
010630512
010630512

That is my line how can I make it look like this :

010630412-1
010630412-2
010630412-3
010630412-4
010630412-5
010630412-6
010630512-7
010630512-8
010630512-9

basically adding dash 1,2,3 and so fourth to every line without changing
the
first set of numbers? Is this possible please explain.