View Single Post
 
Old 10-27-2013, 01:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
as you have given no clue to your location and thus to which your regional settings are ( mm/dd/yy or dd/mm/yy),try it this way:
select the column containing the dates
Data tab - text to columns
Check "delimited"
Click Next twice
Select "Date"
Change the drop down box to MDY
Finish
If it does not work, try variations with the dropdown box.

( giving your approximate location in forum CP helps)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote