Reformat dates
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 |
All times are GMT +1. The time now is 12:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com