Suppose you have a simple text file, with dates and amounts, in the following format.

MAR-04, 123
MAR-05, 100
MAR-06, 456

When I import this into Excel (2002 version), it forces the data imported to be :

04-MAR-2007
05-MAR-2007
06-MAR-2007

I am unable to get the date to be interpreted in any kind of format I can use, such as assuming the 1st of the month. Importing the dates as text gets them in correctly; but then I don't have a way to convert them to dates. The Excel date format, when applied, changes them the same way as the import.

Any suggestions on how I can get the correct date out of this data ?