Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date format problem Nigel Excel Discussion (Misc queries) 7 May 11th 05 12:57 PM
Date Math Problem Dkline Excel Worksheet Functions 4 March 4th 05 04:11 PM
Excel 2002 date formulas problem Andrew Warren Excel Worksheet Functions 4 January 6th 05 11:35 AM
problem with formatting cell to date format Del Excel Worksheet Functions 7 December 8th 04 05:14 PM
Problem with Date format from VBA code twig Excel Discussion (Misc queries) 3 December 7th 04 06:01 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"