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

Please Login or Register  to view this content.

Thanks, Macropod and Pooja.