I am downloading information into excel. One fo the columns is called period/year. The data dumps from the other program in the 0012004 format meaning January, 2004. When I sort it, the information from 2003 isn't showing up first since it is sorting numerically. Is there a way to format that column to make the date show as 04-Jan, 03-May, etc so that it will sort properly?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Desperate for help with date formatting
- Thread starter tarmand
- Start date
Excel Facts
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Tazguy37
MrExcel MVP
- Joined
- May 28, 2004
- Messages
- 4,237
Perhaps try this, instead:
=DATE(RIGHT(CLEAN(A1),4),LEFT(CLEAN(A1),3),1)
That will filter out any nonprintable control characters you might have in there. Also, you might try (somewhere else on the sheet: =ISTEXT(A1)
Does this return true?
=DATE(RIGHT(CLEAN(A1),4),LEFT(CLEAN(A1),3),1)
That will filter out any nonprintable control characters you might have in there. Also, you might try (somewhere else on the sheet: =ISTEXT(A1)
Does this return true?
Upvote
0
Similar threads
- Question
