Dear readers,
I have a document(csv converted to spreadsheet) with bankstatements. Those
statements have a date in the form of MMDD (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
On 29 July 2011 12:29, Koen van Steekelenburg
koenvansteekelenb...@gmail.com wrote:
I have a document(csv converted to spreadsheet) with bankstatements. Those
statements have a date in the form of MMDD (no /'s or -'s). The problem
is that I can't make libreoffice recognise those numbers as
2011/7/29 Koen van Steekelenburg koenvansteekelenb...@gmail.com:
Dear readers,
I have a document(csv converted to spreadsheet) with bankstatements. Those
statements have a date in the form of MMDD (no /'s or -'s). The problem
is that I can't make libreoffice recognise those numbers as
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 MMDD (no /'s or -'s). The problem
is that I can't make libreoffice recognise those numbers as dates. Can
somebody explain
2011/7/29 Regina Henschel rb.hensc...@t-online.de:
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 MMDD (no /'s or -'s). The
problem
is that I can't make
On 29 July 2011 13:36, Regina Henschel rb.hensc...@t-online.de wrote:
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
Mr. Valentine is right. The document consists of imports of several
differently formatted csv-files and added personal notes, so reimport is no
option.
Koen
On 29 July 2011 21:10, T. R. Valentine trvalent...@gmail.com wrote:
On 29 July 2011 13:36, Regina Henschel rb.hensc...@t-online.de wrote:
T. R. Valentine schrieb:
On 29 July 2011 13:36, Regina Henschelrb.hensc...@t-online.de wrote:
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
awesome,thanks
On 30 July 2011 00:06, Regina Henschel rb.hensc...@t-online.de wrote:
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 MMDD (no /'s or -'s). The