Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

At 10:17 17/10/2016 -0400, Charles Marcus wrote: On 10/15/2016 10:02 PM, Brian Barker wrote: At 18:10 11/10/2016 +0100, Tom Davies wrote: Can find get rid of the ' marks to make the values revert to 'numbers/dates' rather than being forced into being text? No. This claims otherwise:

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

On 10/15/2016 10:02 PM, Brian Barker wrote: > At 18:10 11/10/2016 +0100, Tom Davies wrote: >> Can find get rid of the ' marks to make the values revert to >> 'numbers/dates' rather than being forced into being text? > No. This claims otherwise:

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

Hi Tom, Le 11/10/2016 19:10, Tom Davies a écrit : Can find get rid of the ' marks to make the values revert to 'numbers/dates' rather than being forced into being text? Nope. But you may fix that after the import process has run without having to relaunch it. -- Just select the offending

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

At 18:10 11/10/2016 +0100, Tom Davies wrote: Can find get rid of the ' marks to make the values revert to 'numbers/dates' rather than being forced into being text? No. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

Doug McNutt wrote: What I have learned: Most important: Brian is very helpful. Thank you. Dates are really floating point numbers and the unit is one day. Somewhere there must be a way of setting the zero point. 1900, 1904, 1970 are common. Tools > Options > LibreOffice Calc > Calculate >

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

What I have learned: Most important: Brian is very helpful. Thank you. Dates are really floating point numbers and the unit is one day. Somewhere there must be a way of setting the zero point. 1900, 1904, 1970 are common. My startup worksheet came from an old, 2001, Apple version of Excel

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

Hi :) Can find get rid of the ' marks to make the values revert to 'numbers/dates' rather than being forced into being text? Regards from Tom :) On 9 October 2016 at 18:00, Brian Barker wrote: > At 18:01 06/10/2016 -0400, Doug McNutt wrote: > >> Brian had some

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

At 18:01 06/10/2016 -0400, Doug McNutt wrote: Brian had some questions about how I read, with curl and perl5, the csv files which seemed to be applying an apostrophe to dates formatted as MM/DD/. I'm not sure why you think you need to preprocess these documents before using them. It