excel date format

[shar418]

I'm trying to format the date to be 1/30/2009. But it keeps displaying the date plus the time. It isn't doing it in every cell. This spreadsheet has worked fine for a year. This week it starting throwing the times into the cells. I can't get it to reformat.

[ReRun]

Have a peek at the link below, should help you out.


http://www.mvps.org/dmcritchie/excel/datetime.htm