Skip to main content

How to convert date format

The following steps are instructions on how to set a custom date format. 

Step-by-step guide 

ie European format (dd-mm-yyyy)

  1. Enter in Excellentable edit mode.
  2. Enter a date in a cell.
  3. Click on Formats, hover your cursor on Number, and then select on Date and Time Formats.
  4. This will need to be done from the text field. Move around the boxes as Day Month Year.

  5. Next we can fix the dividers as we desire. Click in front of Day and clear the "-".

  6. Click the space in between Day and Month. Type in "-" if it is missing. Repeat the same in between Month and Year.
  7. Click Add Format.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.