----- "Le-shin Wu" <leshin@xxxxxxxxx> wrote: > Hi Adrian, > > Thanks for your information. I think your suggestion will be my last > approach, if I really can not find a way to solve my problem. > Actually, I tried to format the cells type (the "date" column in my > sheet) in Calc as "Date" before I copy and past, but somehow it works > for only once. This also confused me. Thanks again. > > LW > Once the column is formatted as "Date" the underlying value will be the integer value. I did a little test and found the following. If I preformatted a column as "Text" and then entered date strings for example "12/01/09" it stayed a string when cut and pasted. If I just started entering a date string in a column the column would become a "Date" column. Changing the formatting to "Text" would change the date strings "12/01/09" to the underlying integer 40147. Any new date strings entered however would stay as "12/01/09". Hope this helps. Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
