Change Date (24.01.2013) to regular format (01/24/2013)

[Buck1480]

I need to change my dates (over 300,000 rows in Excel) from the current format (General) of 24.01.2013 to a regular date format of 01/24/2013. What is the easiest way to reformat these values, especially given that I have over 300,000 rows worth of dates.

 

[Dave Patton]

Excel 2010
	A	B
1	Date Text	Date
2	24.01.2013	24-Jan-13
11c

Cell Formulas
Range	Formula
B2	=DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))

insert or use an adjacent column
put formula in B2 and fill down
Format the date to your preference

or try
select the range of text dates
use find (.) and replace (-)

 

[Jonmo1]

Try
Data - Text To Columns
Select Deliminated - Next
UNcheck All Options - Next
Select Date - DMY
Finish.