How to disable Excel number autoformat
Solution 1:
Before you enter any values in the column/cells, change the cell format to Text.
Or, put this in the Workbook code module to force this formatting on all sheets, each time the workbook is opened.
Private Sub Workbook_Open()
Dim sh As Worksheet
For Each sh In Me.Sheets
sh.Cells.NumberFormat = "@"
Next
End Sub
Solution 2:
- cut and paste everything into note_pad
- delete what ever left in xl
- Select all needed cells, columns row to text format
- re-paste from note_pad
- if you need later you can change to date, time formats