Format Imported Dates

Bogar

New Member
Joined
Dec 30, 2005
Messages
9
I'm importing data from another source and I'm having a difficult time manipulating the data.

Problem

The date is being imported as 12/30/2005 9:45:30 AM. I'm not concerned about the time stamp for the reporting that I'm doing. How do I remove the time so the date is the only thing left?

I know I've done this in the past, but I'm drawing a blank.

Thanks in advance!

Bogar
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

FineBW

New Member
Joined
Aug 5, 2005
Messages
23
You can you the to text fuction.. Select the text funciton and change the format to MM/DD/YYYY

This should work
 

Watch MrExcel Video

Forum statistics

Threads
1,118,917
Messages
5,575,027
Members
412,635
Latest member
Arren
Top