Converting Dates from text

zoejenka

New Member
Joined
Jun 13, 2006
Messages
28
Hi,

I have got an Access download in excel and the dates have the time attached to them - I am having trouble converting this to just show the date without the time, so I can consolidate the data.

Cheers.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
What format do you have?

If excel recognises the data as a date and time you can extract just the date with

=INT(A1)

where your date/time is in A1
 

Watch MrExcel Video

Forum statistics

Threads
1,114,112
Messages
5,546,012
Members
410,720
Latest member
SSL
Top