>Someone gave me a fixed length file to import into a foxpro table.
>
>To format nicely for import, I load it into excel first, define columns, then export it from excel as a csv (comma delimited.)
>
>The problem is the date fields are in the original file in the format of mmm dd yyyy hh:ssAM/PM -- and I can't get excel to recognize that as a date. I need to export it as m/d/yy, I would be happy if I could create a new column to have the date in the proper syntax, but thus far, no happiness.
>
>Anyone have any good ideas? Thanks!

Todd,

Why use Excel at all? You could just import the original file and then manipulate to any format you want. If you want to send me a sample of the the fixed-length file I would be happy to take a look at it. Make sure it has headers and a short explanation of what you are trying to do.

renoir@bellsouth.net

Renoir