Ask Your Question

Date entered in libreoffice calc as mm/ddd/yy displays as mm/ddd/yy in excel

asked 2018-05-30 05:42:54 +0100

EddyV gravatar image

In excel the ddd is the number of the day since the beginning of the year. For example, 02/15/18 entered in libreoffice calc displays as 02/046/18 in excel 2007-2013 XML (.xlsx). The user defined format code in the format cells dialog is mm/dd/yy;@

How do you get the ddd to display as the day of the current month? In the example above, we want the date to display in excel as 02/15/18

edit retag flag offensive close merge delete


What version of LibreOffice do you use?

kompilainenn gravatar imagekompilainenn ( 2018-05-30 08:50:44 +0100 )edit

ddd in Excel is not the number of days since the beginning of year, it is the day of week short name, the same as in Calc, see also this support article.

AFAIK there is no format code to display days since the beginning of the year.

Which LibreOffice version do you use? AFAIK no version saves mm/dd/yy;@ format as mm/ddd/yy;@

erAck gravatar imageerAck ( 2018-05-30 09:16:39 +0100 )edit

It is version (x64)

EddyV gravatar imageEddyV ( 2018-06-01 13:17:46 +0100 )edit

Format code is saved as MM/DD/YY;@ so whatever your Excel does (if it really switches to a ddd instead of dd and displays it as day of year, which I still doubt) is not what is in the file. At least not if such sample is created afresh. Maybe attach or put your file (cleaned of sensitive data) on a web space somewhere and place the URL here so we can take a look.

erAck gravatar imageerAck ( 2018-06-01 13:42:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-30 16:34:59 +0100

_dave gravatar image

Eddy, Could this help you? C:\fakepath\num_of_days.ods

edit flag offensive delete link more


This is not an answer to the question.

erAck gravatar imageerAck ( 2018-06-01 13:42:44 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-30 05:42:54 +0100

Seen: 118 times

Last updated: May 30 '18