Re: [users] Dates into Calc

2010-11-29 Thread Richard Detwiler
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

[users] Dates into Calc

2010-11-28 Thread Harold Fuchs
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

Re: [users] Dates into Calc

2010-11-28 Thread Brian Barker
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

Re: [users] Dates In Calc - value highlighting

2009-04-01 Thread Anthony Chilco
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

Re: [users] Dates In Calc

2009-03-31 Thread JOE Conner
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

Re: [users] Dates In Calc

2009-03-31 Thread Dave Barton
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

Re: [users] Dates In Calc

2009-03-31 Thread Brian Barker
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

Re: [users] Dates In Calc

2009-03-31 Thread Gene Young
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.

Re: [users] Dates In Calc

2009-03-31 Thread JOE Conner
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,

Re: [users] Dates In Calc

2009-03-31 Thread TomW
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.

[users] Dates In Calc

2009-03-30 Thread Dave Barton
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.