Videos/Format date in Calc

Forword


The Video "Datum formatieren in Calc" (in German [DE]) link to this page here, which contains further information.

This description refers to the version LibreOffice 5.3.

Link to the video
Link to the video (in German [DE]):

Datum formatieren

This video shows how a date can be formatted in Calc.

Possibilities for date formatting
1. Click the icon in the Formatting toolbar "Format as date" or

2. press the buttons.

With both versions can be a number in a Date formatted and vice versa.

3. In the main menu choose.

Adjust date format
Choose in the main menu [[Media:201905_ENLOHB_Menu_Format_Cells.png|]].

The [[Media:201905_ENLOHB_Dialog_box_Format_cells.png|"Format cells"]] dialog opens.

There you select the tab "Numbers".

For "Category" choose "Date".

In "Format" you can choose a date format, e.g. "1999-12-31".

There are one for the format selection [[Media:201905_ENLOHB_Dialog_box_Date_Format.png|large number of formats]] available.

If the format meets your wishes, we click on.

Another option you have in the line "format code".

Here you can create your own formats.

Adapt date format to ISO 8601
For further processing or transmission of data in date format, the standardized international date format is recommended Wikipedia - ISO 8601.

This format, in the following year-month-day, (YYYY-MM-DD = 1999-12-31), is already available as a selection.

If you have selected this format, an appropriate hint will be given below the line "Format-Code".

Note Dates in documents and for Disclosure or Transfer should always be given with a four-digit year.

Documentation / Manuals
Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?
For questions on this topic go to:

Ask.LibreOffice

Get Involved
Join us today and help us to make it even better!

Get Involved

Donate
LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.