On Wednesday, June 25, 2014 04:52:24 PM Budgie wrote: > 25 Jun 2014 Not sure about openoffice but in LibreOffice you can start calc, go to Format -->Cells --> Date and create a format like you want by inserting in the Format Code box what you want:
Example: DD/MM/YYYY this will give 25/06/2014. Then go to the spreadsheet column, highlight it or just the cells you want to have it. When you insert a date in the formatted empty column it will appear as the format you want. Russ -- openSUSE 13.1(Linux 3.11.10-17-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-331.79)|KDE 4.13.2 -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
