I never know which to try first so I try DMY and see what happens.

Then MDY or YMD or whatever.

I think there is a system but I haven't found it yet.


Gord


On Mon, 27 Nov 2006 17:53:01 -0800, pclifford99
wrote:

Got it, thanks. I went back and tried DMY. that convererted it to the format
i needed. I started with data listed as day/month/year so i am not sure why
entering DMY would convert to (month/day/year). I'd be curious just to know
and learn something. any idea ?

thanks
phil


"Gord Dibben" wrote:

Perhaps your dates are text and not dates.

Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish.


Gord Dibben MS Excel MVP

On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99
wrote:

for whatever reason, that does not work. i've tried it about a dozen times.
i've cut and pasted "values only" to other parts of my spreadsheet thinking
maybe the format was corrupted, but no go. any furthur ideas ?

thanks