How to convert text 'Jun-30-2007' to date format?

N

Nick Hodge

Kenny

if it is in a format that can be recognised by Excel (dd/mm/yyyy,
mm/dd/yyyy, dd-mm-yyyy, etc) then use

=DATEVALUE(A1)

Where A1 has the text date. Then format the resulting serial number as a
date

If you only want to 'kick' the text dates to proper dates, try copying a
blank cell, highlighting the 'text dates' and then Edit>Paste
special...Values+Add. Then format the serial number as date

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
T

Teethless mama

Data > Text to Columns > Next > Next > Under Column data format select Date >
Finish
 
Top