Hi Koen,
Koen van Steekelenburg schrieb:
Dear readers,
I have a document(csv converted to spreadsheet) with bankstatements. Those
statements have a date in the form of YYYYMMDD (no /'s or -'s). The problem
is that I can't make libreoffice recognise those numbers as dates. Can
somebody explain how I can make Libreoffice recognise the YYYYMMDD numbers
as dates.
In the csv import dialog is a preview of the data. Click on the column
header of the date column. This enables the 'Column type' drop down
list. There choose 'Date(YMD)'. Now the dates should be recognized as
date already when importing the document.
Kind regards
Regina
--
Unsubscribe instructions: E-mail to users+h...@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
