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
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
At 13:31 28/11/2010 +, 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
TomW wrote:
For issues like this, I like the 'value highlighting' option in Tools |
Options | OpenOffice.org Calc | View. Anything that is a number is a
blue font. Text is displayed in a black font. The two
Dave Barton wrote:
In all the years I have been using OOo it surprises me that I have not
stumbled on this issue before.
Format an empty Calc cell with an ISO 8601 date format (ie. -MM-DD)
and then type, or paste, a date in US format (ie. MM/DD/) into the
cell and the date is displayed
Original Message
From: JOE Conner joeconner2...@gmail.com
To: users@openoffice.org
Date: Mon, 30 Mar 2009 23:26:24 -0700
Dave Barton wrote:
In all the years I have been using OOo it surprises me that I have not
stumbled on this issue before.
Format an empty Calc cell with
At 22:54 31/03/2009 +1100, Dave Barton wrote:
From: Joe Conner joeconner2...@gmail.com
Date: Mon, 30 Mar 2009 23:26:24 -0700
Dave Barton wrote:
Format an empty Calc cell with an ISO 8601 date format (ie.
-MM-DD) and then type, or paste, a date in US format (ie.
MM/DD/) into the cell
Brian Barker wrote:
At 22:54 31/03/2009 +1100, Dave Barton wrote:
From: Joe Conner joeconner2...@gmail.com
Date: Mon, 30 Mar 2009 23:26:24 -0700
Dave Barton wrote:
Format an empty Calc cell with an ISO 8601 date format (ie.
-MM-DD) and then type, or paste, a date in US format (ie.
Dave Barton wrote:
Original Message
From: JOE Conner joeconner2...@gmail.com
SNIP
Calc stores dates as numbers. I suspect that if you reformat the cells
as numbers they would all convert.
Then once again reformat the cells as the date string you need.
Joe Conner, Poulsbo,
JOE Conner wrote:
Dave Barton wrote:
Original Message
From: JOE Conner joeconner2...@gmail.com
SNIP
Calc stores dates as numbers. I suspect that if you reformat the cells
as numbers they would all convert.
Then once again reformat the cells as the date string you need.
In all the years I have been using OOo it surprises me that I have not
stumbled on this issue before.
Format an empty Calc cell with an ISO 8601 date format (ie. -MM-DD)
and then type, or paste, a date in US format (ie. MM/DD/) into the
cell and the date is displayed as entered.
11 matches
Mail list logo