Advertisement
chengtie

Untitled

Dec 16th, 2021
1,637
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub convertToNonNumbers()
  2.     Application.Calculation = xlCalculationManual
  3.     For Each cell In Selection.SpecialCells(xlCellTypeConstants)
  4.         x = CStr(cell.Value)
  5.         cell.ClearContents
  6.         cell.NumberFormat = "@"
  7.         cell.Value = x
  8.     Next
  9.     Application.Calculation = xlCalculationAutomatic
  10. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement