How do I had a suffix to a cell i.e. -1,-2,-3?

You need VBA code to do this.

Sub AAA()
Dim Rng As Range
Dim N As Integer: N = 1
For Each Rng In Range("A1:A5") ' change range as needed
Rng.Value = Rng.Text & "-" & Format(N, "0")
N = N + 1
Next Rng
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"controller_woman"
wrote in message
...
How do I had a suffix to a cell i.e. -1,-2,-3?