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
Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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
