Hi Diane

I assumed the dates were in column A and started at A1.
Substitute your actual cell references into he formula e.g. if your dates
are in column F starting at row 3, then change the formula to
=MID(F3,FIND(" ",F3)+1,2)&"-"&LEFT(F3,FIND(" ",F3)-1)&"-"&RIGHT(F3,4)

hope this is clear, but if not post back.

Regards

Roger Govier


DianeMcP wrote:
Hi Roger,
In your sample, is the A1 supposed to be the date column? or should I
substitute the A1 for the actual column being used for dates?