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 <[email protected]> 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: [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
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: [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
