My macro is copying data in error

I am trying to create a macro to use the data "Text to column" function to convert a column of data to text. (Just so you understand how I'm creating the macro - I highlight the column (A) and hit ALT DEWNNTF)

A B C D
INV USER MNO SCRNO
9242852 38026 6966 A2046443
9243250 06046 6948 BS047985
9243293 20123 7594 AM051514
9243282 31153 2822 AU045045
9243280 04218 2552 BU122874
9243260 02031 1223 A0232935

What ends up happening after I record the macro (say on column A) and try it on another column (say B) is that the data from column B is copied to column A. If I do column C, then A has the data of column C.

A B C D
USER USER MNO SCRNO
38026 38026 6966 A2046443
38026 06046 6948 BS047985
20123 20123 7594 AM051514
31153 31153 2822 AU045045
04218 04218 2552 BU122874
02031 02031 1223 A0232935

I don't know if it's the way I'm creating the macro, but I'm not sure why it's copying the infomation and not sure how to create the mcro correctly to do what I want.

Can anyone help?