Harold Fuchs wrote:
Thanks, Andreas. That works. I didn't realise that "Fri Apr 30" is US
English and *not* British English. Looks perfectly OK to this Brit.
Well, as a German I think that the computer program interpretes these
expressions as US dates simply because the month portion is followed by
the day portion as in 12/31/1999.
When importing csv into Calc you can also specify most of the gory
details within the text import wizard where you can select single
columns or all columns (clicking the top-left corner) and assign some
evaluation method.
"Standard" means: "Just treat the text strings between as if I would
type them into unformatted cells"
Option "Text" turns everything into literal text values. Numeric
evaluation is supressed for all numeric expressions (indicated by a
leading apostroph in the formula bar which is not part of the text value).
Then there are 3 different flavours of date evaluation: DMY,MDY and YMD
Plus a setting for "English(US)" which is useful with comma locales like
German where the comma is the decimal separator as in 3,1459
Unforturnately, all this is not properly documented.
The F1-help says:
Date (MDY)
Applies a date format (Month, Day, Year) to the imported data in a column.
Which is misleading because the applied number format (the one you see
on the sheet) is simply the default one for any unformatted cell in a
blank new sheet. This depends on the currently active applicationlocale.
It should read like:
Date (MDY)
Evaluates a column of dates as sequence of Month, Day and Year
(12/31/1999, 12-31-99, Dec 12 99 and alikes)
Spreadsheet documentation is pointless since nobody reads it anyway.
Have a nice Easter weekend,
Andreas Säger
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
