Help for convertion of text to general / number format

Dear All

I am trying to create Macro for convertion of number stored as text to general / number format but unable to convert data of Cell # A1, A2 with following VBA code. However, Value in A3 is prefectly converting to general.

Sub Test()
With Columns("A")
.NumberFormat = "General"
End With
End Sub

File is also attached in email for your reference.

Need your help to resolve this issue