Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reformat columns | Excel Discussion (Misc queries) | |||
Reformat Row to Column | Excel Discussion (Misc queries) | |||
Reformat numbers | Excel Discussion (Misc queries) | |||
Reformat spreadsheet | Excel Worksheet Functions | |||
Reformat of a table | Excel Discussion (Misc queries) |