Format date in Calc

    From The Document Foundation Wiki
    Other languages:

    Forword

    large number of formats

    The Video "Datum formatieren in Calc - LibreOffice" links to this page here, which contains further information.

    Link to the video

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

    Datum formatieren

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

    Format date in calc

    Possibilities for date formatting

    1. Click the icon in the Formatting toolbar 7451DE Calc Symbol Datum.png "Format as date" or

    2. press the buttons Ctrl + ⇧ Shift + 3.

    With both versions can be a Number 7451EN Calc Number.png in a Date 7451EN Calc Date.png formatted and vice versa.

    3. In the main menu choose Format ▸ Cells….

    Adjust date format

    Choose in the main menu Format ▸ Cells….

    The "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 large number of formats available.

    If the format meets your wishes, we click on OK.

    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 pin.svg

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

    Further informations

    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

    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.