Date time format to date only

  • Thread starter Thread starter aliya.pawaskar
  • Start date Start date
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
 
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.
 
If, rather than just formatting into a date format, you want to convert the
data to date only, use =INT(A1)
 
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

Similar Threads

format date 5
Count Dates 2
Convert text date to mmddyyy date 2
date format 1
Copnvert dates reading as Text to a date format 5
Excel 2007 displayed dates 2
Date Formats 1
How to show only Month of a mm/dd/yyyy format? 4

Back
Top