Am 29.11.2010 10:51, Harold Fuchs wrote:
On 29 November 2010 07:22, Andreas Säger<[email protected]> 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.
Sorry, I missed the point that you want next year's dates. Without a
given year number Calc assumes this year.
After importing this year's dates in US context you could search for
2010 within formulas and replace with 2011.
The formulas for constant date values use to have 4-digit years.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
