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