I just attempted this in Feisty with Open Office 2.2, the formatting seems to stick but if I double click on it, then I see the DD/MM/YYYY Format shown instead which is just how the program stores it. Which version of Ubuntu and/or OpenOffice are you running?
-- Date format inconsistent https://launchpad.net/bugs/95118 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs