Re: [libreoffice-users] Re: How to reverse a date format

On Mon, Jul 17, 2017 at 7:26 AM, V Stuart Foote <VStuart.Foote@utsa.edu> 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: 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