Formatting cells

[Doug Mc]

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

 

[BetaDocuments]

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

Are you sellecting the dates "only" rows or column or cells and
adjusting it?

Select cell then right click then change the format. Is that what you
doing?

 

[Doug Mc]

Yes, that's what I'm doing and it helped in some cases; however I still
can't get some to re-align.
Also, I can't seem to get rid of the dollar sign....

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

Are you sellecting the dates "only" rows or column or cells and
adjusting it?

Select cell then right click then change the format. Is that what you
doing?

 

[Roger Govier]

Hi Doug

You could use a new sheet.
Format each column the way you want it.
Copy your source data again.
Paste Special>Values

 

[Doug Mc]

Thanks Roger,
I'll give that a try.

Hi Doug

You could use a new sheet.
Format each column the way you want it.
Copy your source data again.
Paste Special>Values

 

[Doug Mc]

Hi Roger
I tried that and it didn't work. Took it as the original appeared.
I don't know why. It ought to work!

Doug

 

[Doug Mc]

Still have that dollar sign!
Tried copying to a new sheet but it took the dollar sign with it - even when
I Pasted Values.....


Doug

 

[Roger Govier]

Hi Doug

Do you want to send me a copy and I'll see if I can figure out what is going
wrong?

To mail direct
roger at technology4u dot co dot uk
Change the at and dots to make valid email address