View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
BetaDocuments BetaDocuments is offline
external usenet poster
 
Posts: 18
Default Formatting cells

On Jan 26, 3:49*pm, "Doug Mc" wrote:
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?