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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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,652
Messages
5,549,210
Members
410,905
Latest member
Extjel
Top