Probably the cells aren't really dates, but text. You can check with the
ISTEXT() function.
If they are text, formatting doesn't have any effect.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"bondam" wrote in message
...
I want to format a column that contains date and time and I want it to show
just the date and not the time. Going into format and clicking on the date
and changing doesnt work.