If I read it right, you just need to format the cells

Right click, select format cells, General Tab, Custom (bottom of the list)
and if not already provided, type in the format you want eg.

dd/mm/yy - 25/05/10
mm/yyyy - 05/2010
mmm/yyyyy - May/2010

and so on.

If this helps, please click yes

"jknapp1005" wrote:

I have a problem. I keep trying to format the date in certain cells, and it
keeps wanting to add the time. The date is pasted in from worksheets where I
had used a NOW() formula, but I had just pasted in as values to the new
worksheet. No matter what I've tried as far as changing the format, it just
keeps showing the time. How can I keep the date, but get it to stop showing
time?