On Mon, Jul 17, 2017 at 7:26 AM, V Stuart Foote <[email protected]> wrote: > Wade Smart wrote >> This spread sheet has several columns of dates >> written MM/DD/YYYY. I need to reverse it to >> YYYY/MM/DD... > > You can not change the internal format of the dates. > > If they are columns of Dates in an ODF spreadsheet they do not need to be > changed--actually can not be changed--rather you just need to change their > display format. Select the column, the Format -> Cells and in the dialog > select Date and a format you need. The YYYY-MM-DD is predefined. Or you can > add a format code to use an alternate separator. > > If the file is CSV, set it as date during import and set the display format > needed.
Well, that fixes one column. Ill have to figure out the rest then. Thanks for the information. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- 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
