vba format cell as text code example
Example: excel vba change number format of cell to text
'VBA to change the Number Format of cell A1 to text:
[A1].NumberFormat = "@"
'VBA to change the Number Format of cell A1 to text:
[A1].NumberFormat = "@"