https://bugs.documentfoundation.org/show_bug.cgi?id=140840
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Mike Kaganski <[email protected]> ---
This is not a bug. A number like "20070320" is a number. It cannot be treated
like a date, because it would break working with numbers.
However, you might import the column as text, and then post-process the data in
it using things like =DATE(LEFT(A1;4);MID(A1;5;2);MID(A1;7;2)), or to split the
imported column using Data->Text to Columns with "Fixed width" option, to
separate the parts of the date.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
