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 Sun May 2 Sun May 2 Mon May 3 All the dates are *this* year. If I simply copy/paste those values into Calc I get 01/04/30 01/04/30 01/05/01 01/05/01 01/05/02 01/05/02 01/05/03 If I format the column "DDD MM DD" which should show e.g. Mon 18 May, then I get Tue Apr 01 Tue Apr 01 Tue May 01 Tue May 01 Wed May 01 Wed May 01 Thu May 01 Right format but wrong values. Note that in each case, the first date shows on the Input line as 01/04/1930, the last as 01/05/2003. The "dd/mm" style is right from me because I use European format as opposed to the US style "mm/dd". Help. Please. -- Harold Fuchs London, England Please reply *only* to [email protected]
