I have not used the Calc program in this format but I used to use an old
suite of programs called DataStar and it was one of the original integrated
packages. When brining dates into Datacalc I had to change them all to
number days with slash bar "/" seperators before inporting. I don't know
that it will work for our Calc but it doesn't take long to use Find/Replace
to change something like this and it just may work.
Good luck.
Mick
----- Original Message -----
From: "Andreas Säger" <[email protected]>
To: <[email protected]>
Sent: Monday, November 29, 2010 2:22 AM
Subject: [users] Re: Dates into Calc
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
