Dates importing in US format

Updated 3 years ago

If you are importing dates to the ClickSend dashboard and they are converting to a US format you will need to update the formatting in your Excel file.

  1. Open your file in Microsoft Excel
  2. Right-click the column containing dates
  3. Select "Format cells"
  4. Click "Date" under Number >> Category
  5. Ensure the Location (Language) is set to be United Kingdom (English)
  6. Select formatting that shows the date in the dd/mm/yyyy format

How Did We Do?

Powered by HelpDocs (opens in a new tab)