Sub macro() Range(“P:P”).Select With Selection Selection.NumberFormat = “General” .Value = .Value End With ActiveWorkbook.Save End Sub