If you change a cell that has a year in it to YYYY it will show the wrong information because the cell is really a date, so you need a full date in the field regardless of what you want to display. If you set all the cells to text or number and then sort it should work fine.
Do you still have problems after choosing to do one of the above? Chris ** Changed in: openoffice.org (Ubuntu) Status: New => Incomplete -- formating as year = all cells are set '1905' https://bugs.launchpad.net/bugs/396559 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs