I have to chage the format of Price 123.42 to $123.42 but in the beggining of
123.42 there is a space and I tried to go to format and click into the $ but
that wont happen.

I have 1000lines where I have to change to 123.42 to $123.42 but because of
the space I have to delete the space then go to format and $ sign.

I can't copy and do paste special it won't let me.

Column A Column B
123.41 $123.41