Date time format to date only

A

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
 
F

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

David Biddulph

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top