I copied some cells from a sheet to a new sheet.
The cells I copied contained some numbers and dates.

Some of the numbers had a dollar sign on them. I wanted to remove the
dollar signs..
The dates were not formatted like I wanted them (mm/dd/yy) rather than
mm/dd/yyyy.
Some of the columns had left-justified data and I wanted to change them to
be right-justified.

I've beem tryint to reformat the cells and nothing seems to work.
What am I doing wrong?

Thanks,
Doug