Re: [users] Re: Date Interpretation - Calc

2010-04-02 Thread Harold Fuchs
On 1 April 2010 17:16, Andreas Saeger saege...@onlinehome.de wrote: Harold Fuchs wrote: OOo 3.1.1 on Win XP Pro. I have a column of dates in a text (.txt) file and want to copy them into a column of a Calc sheet. I can't because Calc insists on changing the values. The first few lines

[users] Re: Date Interpretation - Calc

2010-04-02 Thread Andreas Saeger
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

[users] Re: Date Interpretation - Calc

2010-04-01 Thread Andreas Saeger
Harold Fuchs wrote: OOo 3.1.1 on Win XP Pro. I have a column of dates in a text (.txt) file and want to copy them into a column of a Calc sheet. I can't because Calc insists on changing the values. The first few lines of the .txt file look like this: Fri Apr 30 Fri Apr 30 Sat May 1 Sat May 1