On Nov 11, 2:08*pm, Revenue wrote:
Wasn't exactly the approach I had in mind, but I finally incorporated
that approach of multiplying by 1 into a macro and it works.

If you insist on a macro, try:

Sub doit()
Selection.NumberFormat = "General"
x = Selection.Value
Selection.Value = x
End Sub