sandrussca1
New member
- Joined
- Aug 3, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hello Guys,
I am new to the forum and just remembering old times with Excel and just started using the latest version (2013).
I got a database with dates in this format:
="month day, year" or
="November 21, 2013"
When filtering, I don't have the option to sort by date, but by "A to Z letters".
I want to be able to sort this column by dates, but it seems the formatting needs changing.
I've tried changing by going into format cell > and choosing the date category, but I'm still unable to filter by dates.
Can you please help me change date formatting without doing it manually? I've already tried with functions, but it doesn't seem to work either.
Any kind of advice is valuable.
Thanks a lot!
I am new to the forum and just remembering old times with Excel and just started using the latest version (2013).
I got a database with dates in this format:
="month day, year" or
="November 21, 2013"
When filtering, I don't have the option to sort by date, but by "A to Z letters".
I want to be able to sort this column by dates, but it seems the formatting needs changing.
I've tried changing by going into format cell > and choosing the date category, but I'm still unable to filter by dates.
Can you please help me change date formatting without doing it manually? I've already tried with functions, but it doesn't seem to work either.
Any kind of advice is valuable.
Thanks a lot!