Likely, your data is just text, then. You can try fixing it with "data isn't
recognized" at:

http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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.