[libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Koen van Steekelenburg
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread T. R. Valentine
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Johnny Rosenberg
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Regina Henschel
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Johnny Rosenberg
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread T. R. Valentine
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Koen van Steekelenburg
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:

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Regina Henschel
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

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread soumalya ray
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