Thread: Date Problem
View Single Post
  #1   Report Post  
Dutyman
 
Posts: n/a
Default Date Problem

I'm new to excel and self-taught, so bear with me. I've imported a text file
of approximately 250 records into excel 2003 with one of the fields being a
date in the format dd/mm/yyyy - the year ranges from 1600 to 2005 so it needs
to be four digits. What is the simplest way to get the field into a
structure where I can sort the records into date sequence?