On 10/15/2016 10:02 PM, Brian Barker <b.m.bar...@btinternet.com> wrote: > At 18:10 11/10/2016 +0100, Tom Davies wrote: >> Can find&replace get rid of the ' marks to make the values revert to >> 'numbers/dates' rather than being forced into being text?
> No. This claims otherwise: http://www.ryananddebi.com/2009/11/29/remove-apostrophes-before-numbers-in-openoffice-calc/ Also, if I recall I dealt with this a long time ago and there is an Addon/Extension that can accomplish this... let me go look... Yes, the CT2N extension... http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted