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?