Re: [libreoffice-users] Calc question on dates in formulas

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: users+unsubscribe@global.libreoffice.org
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