how can i change european date format to american
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
|