Hello
May be with this simple macro it would do the trick (select cells prior to
running macro):
Sub ValidateCells()
For Each c in Selection.Cells
c.Value = c.Value
Next c
End Sub

HTH
Cordially
Pascal