if i manually import text (csv) remove coulmn and save it is ok

"3110201313505900009997404","3110201313510010909997404","3110201313510010909997404"

if i record a macro to do this plus added code and then run it it does the to the data adding "" and puting , in the wrong places

"3110201313505900009997404,""3110201313510010909997404"",""3110201313510010909997404""

seems its not acting the same

any help would be huge