Dave Barton wrote:
In all the years I have been using OOo it surprises me that I have not
stumbled on this issue before.
Format an empty Calc cell with an ISO 8601 date format (ie. YYYY-MM-DD)
and then type, or paste, a date in US format (ie. MM/DD/YYYY) into the
cell and the date is displayed as entered. Reformatting the cell after
the date is entered does not change it to ISO 8601 format.
My understanding was that Calc recognised different date formats and
translated them according to the cell format. If this is not the case,
could anyone suggest a method of translating the dates in an existing
600+ row sheet from MM/DD/YYYY to YYYY-MM-DD
TIA
Dave
Calc stores dates as numbers. I suspect that if you reformat the cells
as numbers they would all convert.
Then once again reformat the cells as the date string you need.
Joe Conner, Poulsbo, WA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
