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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

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,509
Messages
5,548,486
Members
410,839
Latest member
MrSumo85
Top