Date time format to date only

[aliya.pawaskar]

Hi,

I need help to convert a column that is in date time format eg. 12/31/2008
2:33:25 PM into just a date format eg. 12/31/2008 <mm/dd/yyyy>

Please help

Thanks
Aliya

 

[Gary''s Student]

Select the column and:

Format > Cells... > Number > Custom > mm/dd/yyy

 

[Fred Smith]

Select the columns, right click, choose Format Cells...>Date and choose the
date format you want.

If that does not work, it means you have text, not dates. Convert them to
dates, then format them.

Regards,
Fred.

 

[David Biddulph]

If, rather than just formatting into a date format, you want to convert the
data to date only, use =INT(A1)

 

[Harald Staff]

Note that if you format the time away, you are only hiding it, not removing
it. Excel is not wysiwyg. For real conversion, use a helper column with a
formula like
=INT(A1)
format as mm/dd/yyyy

HTH. Best wishes Harald