Reformat dates

  • Thread starter Thread starter GARY
  • Start date Start date
G

GARY

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reformat dates 1
weeks in a month 1
How to get the following data ... How to create the formula for below 1
excel won't sort dates correctly 0
calculating values where it depends on the value of a previous cel 2
Transpose data from columns to rows 3
Find the position of a date 6
Calculating Days Late 1

Back
Top