Hi :) So that's a yes. The under-laying data remains unchanged so the format just displays it differently.
Regards from Tom :) ________________________________ From: planas <[email protected]> To: [email protected] Sent: Tue, 26 July, 2011 22:48:50 Subject: Re: [libreoffice-users] Calc. Changing format of data types Steve On Wed, 2011-07-27 at 09:16 +1200, Steve Edmonds wrote: > If I have a string in a cell, say 30/08/2011 and the format is general > (I don't know what types the data) can this be changed to a date data > type without having to re-enter all my data. > steve > You can change the data type without re-entering. If the format chosen incorrect, say you entered mm/dd/yyyy and the format selected was dd/mm/yyyy it may not correctly understand the alternate format. Dates formats are controlled by the local formating rules; US normally uses mm/dd/yyyy while most others use dd/mm/yyyy. -- Jay Lozier [email protected] -- Unsubscribe instructions: 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 -- Unsubscribe instructions: 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
