Re: [libreoffice-users] Cannot Change Date Format in Calc

On 17/03/14 20:38, Tom Davies wrote:
> Hi :)
> Is this related to the thread being handled by Brian?  If so the
> problem might be that you are trying to store the date as a
> text-field.  It should be reasonably easy to change the text-format to
> a date one though.
>
> I think the date has to be stored as a numerical value in order to be
> read in as a date.  Then just applying the appropriate date format
> should display the date as required.
>
> Regards from
> Tom :)
>
>
> On 17 March 2014 20:30, Budgie <ajebay@errichel.co.uk> wrote:
> > I have an .ods file and a column with dates in it resists all my attempts to
> > change the format.  The column was created when I opened a .csv file in Calc
> > and the dates were shown as, for example, 12 Feb 2014.
> > At some time during the editing of this file the dates became shown as
> > 12-Feb-14 but I have not intended this change.  What I want is date in
> > DD/MM/YYYY format.  I can highlight the column and try and format it but
> > nothing changes.  Am I doing something wrong here?
> > Budgie
> >
> > --
> > 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
Hi Tom,
Thanks for the reply.  Your explanation is what I too suspect and yes it 
is related to what I have been working on with Brian's help.  I am not 
so confident however about your "reasonably easy to change the text 
format to a date."  Do you have any suggestions?
Budgie

--
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