What happens if you format as Currency with $? Or is that what you mean by
"format and $ sign"? Blanks in front of numbers should be ignored

"Cynthia Amrit" <Cynthia wrote in message
...
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