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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

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,108,960
Messages
5,525,913
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top