Hello,
Attached two samples of spreadsheets (xlsx files).
Both opened with “LibreOffice Portable” version 24.2.1.
Sample-01 spreadsheet downloaded from Creditcards transactions, Sample-02 spreadsheet downloaded from Bank transactions.
In Sample-01 the Date is something but not a Date. In Sample-02 the Date is normal.
Note: Tried to open Spreadsheet Sample-01 with MS Excell - Date is normal.
How to fix it, please.
Answers will be appreciated.
Thanks
Motim
OS Windows 10 pro, 19045.4170 x64
In Excel and Calc 45375 is the true cell value. Formatted as date, 45375 is displayed as 2024-03-24. If some cell displays 45375, 2024-03-24 or $45,375.00 makes no difference unless the cell value is a text.
In both applications 45375 is the count of days after the reference date 1899-12-30.
Hello,
Although my respond is a little late, but still, thanks for the answers.
There is something I cannot understand: The Excell file I download, I open it in MS office it shows the dates, same file opened in LibreOffice, it shows in the same column that strange numbers.
As far as I can remember, in previous versions the date column was ‘normal’.
However, from your answers, when I open the file, first I select the date colomn and in the ‘Format cells’ I set it to ‘Date’.
Thanks again
Motim
From my experience (wich drove me to use OpenOffice on my job) Excel makes some assumptions on the formatting of csv and imports accordingly. If these are right all is fine, if they are wrong, you are in trouble.
.
In many cases they can do it, because they are the big gorilla not to be ignored and some software just uses M$-defaults as their pattern. I had a banking software not documenting change in their “new” format for imports, but there was a picture obviously from Excel. So I exported once ods>xlsx, then used Excel to export and documented the result as format to use in (then) LibreOffice. As english is not my native setting, Charsets are important here and M$ defaults are often false: Some banks export american style, some with german dates and dot and comma have to be checked…
.
And the main problem is: There are a lot of different formatted csv-files out there, wich formatting is sadly not found inside the file.
1 Like