0
votes
0answers
19 views

LibreOffice Calc time formatting trouble

So I'm calculating a time sheet with LibreOffice with this sum column. 00:00 08:00 08:00 08:00 08:00 08:00 00:00 04:00:00 PM The printing format of the bottom row is Time 876613:37:46 but that's ...
0
votes
1answer
163 views

How to prevent Excel to use the OS regional settings for date patterns in formulas

According to this question I have the following problem: I want to use some Excel function (not the cell formatting) like TEXT(A1, {date_pattern}) But the person who answer my previous question make ...
1
vote
1answer
84 views

Libreoffice: format field yyyymmdd to date

How can I format a field value like 20140226 to 2014-02-26 in LibreOffice? If I use the format cell option I get strange values.
2
votes
3answers
10k views

Custom Date Format in MS Word 2010

I have a date field in a Word document which was created from a template included with Microsoft Word 2010. The default setting for this field is to display only two places of the current year. I ...