Pastebin

xlcalculationmanual value

xlcalculationmanual value from Pastebin

    
        Sub convertToNonNumbers()
    Application.Calculation = xlCalculationManual
    For Each cell In Selection.SpecialCells(xlCellTypeConstants)
        x = CStr(cell.Value)
        cell.ClearContents
        cell.NumberFormat = "@"
        cell.Value = x
    Next
    Application.Calculation = xlCalculationAutomatic
End Sub