Hi Tom,
Le 11/10/2016 19:10, Tom Davies a écrit :
Can find&replace 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 column
-- Go to Data > Text to columns.
You'll get into a dialog similar to the text import one.
-- Go to the lower panel and select the column by clicking its heading.
-- In the Column type list, select the appropriate format for the data.
Here, it would be Date (YMD).
-- Click OK.
You're done.
HTH,
--
Jean-Francois Nifenecker, Bordeaux
--
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
