Hello

I have simple problem with a simple keyboard macro.
I am coping from internet banking and pasting banking
statements in excel. Unfortunately, the numbers are in
text format because the coping inserts a space infront of
all the numbers. I have tried functions to remove the
space. No luck. so I pressed the following key sequence;
f2, home, delete, enter. Great the leading space is gone.
I then go to record a keyboard macro with same key
storkes. It does not work. What happeens when I run the
macro is that number in the cell where I made the macro is
copied to all other cells. For example:

if the number in a cell is 29.99 and I record the macro
with the above key stokeds and run it in another cell it
copies 29.99 in all the cells. Can anyone tell me what is
wrong. Also, I looked at the macro the keystorkes, they
are wrong. For some reason Excel is not recording
keystorkes properly. Any help is apprecaited. Please
reply to . Thank you all.