Results 1 to 4 of 4

Thread: How do I add a date with a unknow (xxx) month?

  1. #1

    Question How do I add a date with a unknow (xxx) month?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I've put together my music CDs collection in a Excel files, listing all the CDs I have.
    I also included the dates I purchased every CDs.

    The problem I have, is that I have a few CDs I don't remember the exact month, so I would enter xxx-06 for 2006. However, obviously this break sorting - when I sort by purchase date, xxx-06 is listed last, while it should be listed first before jan-07 and others.

    How can I list a date if I don't know the exact month?

    Thanks for helping out, I appreciate

  2. #2
    Use 000 instead of xxx!

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Use 000 instead of xxx!
    Unfortunately, sorting still doesn't work. 000-06 still end up at the end of the list;

    Click image for larger version. 

Name:	2015-01-19_123024.jpg 
Views:	9 
Size:	95.8 KB 
ID:	3078

    Thanks for your help

  4. #4
    That is because it is text, so you could try a date of 01/mm/1900 instead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •