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
jslozier@gmail.com

-- 
Unsubscribe instructions: E-mail to users+help@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