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

Select the column and:

Format Cells... Number Custom mm/dd/yyy
--
Gary''s Student - gsnu200831

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.

"aliya.pawaskar" wrote in message
...
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

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

"aliya.pawaskar" wrote in message
...
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

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


"aliya.pawaskar" wrote in message
...
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