On 29 November 2010 07:22, Andreas Säger <ville...@t-online.de> wrote:
> Am 28.11.2010 14:31, Harold Fuchs wrote: > >> OOo 3.2.1 Vista Home Premium, Calc >> >> I have a web page showing a table of dates and associated events. The >> dates, all in the same year (2011) are in the style, for example "Sun >> Oct 23". If I copy/paste the table into Calc, the example date I just >> gave comes across as 01/10/2023. How do I fix this so that the dates >> come across "correctly"? >> >> Calc's Paste Special option doesn't seem to help. >> >> I have tried saving the table as a CSV file by copy/pasting the web >> table into a text editor and then opening that file in Calc but the >> result is the same. >> >> > Hi, > Choose locale "English(US)" in the language options. > Greetings, > Andreas > > > Thanks. Unfortunately doing this causes the dates to be interpreted as belonging to this year (2010) so the day names are all wrong. I found two workarounds but they are both messy: first copy/paste the data into a text editor and then either use a regular expression (RE) to put a single apostrophe before each date thus causing Calc to treat them as text or use an RE to append " 2011" to each date and then use CSV (tab-separated) import to get the data from the text editor into Calc. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org