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 of the .txt file look like this: >> Fri Apr 30 >> Fri Apr 30 >> Sat May 1 >> Sat May 1 >> > > Tools>Options...LangSetting>Languages: Application locale <English (US)> > Do the import of the US figures. Switch back to your prefered locale once > you've got the right values. > > > 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. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org