If the dates are real Excel dates, you can format as mmm d

If they are not Excel dates but text, you can either change them to dates
first, or just shuffle the text by =RIGHT(A2,3)&" "&LEFT(A2,LEN(A2)-4)
--
David Biddulph


"GARY" wrote in message
...
Dates are displayed as follows:
31-Aug
9-Sep
15-Sep
31-Oct
1-Nov

How can I get the dates to be displayed as follows:

Aug 31
Sep 9
Sep 15
Oct 31
Nov 1