Date Conversion
USA dates are usually m/d/yy
Your date may be text.
Try DataText to ColumnsNextNextDate Column FormatDate and MDY
Then format to d/m/yy
Gord Dibben MS Excel MVP
On Sat, 8 Mar 2008 14:36:04 -0800, Pat wrote:
Hi Gary that does not work, stays in the same format.
I have 10/05/2007 when I need it to be 05/10/2007 can anybody help?
|