how to add a "+" to a number in a cell

[Martin]

I need to change a lot of phone-numbers in my Excel-sheet, by adding a " + "
to the country prefix.
How do I do that?
When I use "Search" / "Find", and write the paragraphs " + * " in the
replace box, it erase the whole number instead of adding the "+".. Which
wasn’t what I was looking for …

 

[Gary''s Student]

select the cells and run this macro:

Sub plus_it()
For Each r In Selection
r.NumberFormat = "@"
r.Value = "+" & r.Value
Next
End Sub