Dates Show as NaN or #VALUE! in Excel

NaN, #VALUE!, or raw text like 15/03/2024 appearing in the Date column of your Excel export means Excel's regional setting doesn't match the date format DocuClipper used when writing the file. Excel couldn't parse the string into a real date, so it kept it as text.

The fix is to pick a different date format when you download (no need to re-convert).

The Date Format setting only controls how dates are written on export — it doesn't change how DocuClipper read the dates, so there's no need to re-convert.

1. In the project, click Download Data to open the Download your data dialog.
2. In the Date Format dropdown, pick one that matches your Excel regional setting:
   • US Excel → MM/DD/YYYY
   • UK / EU Excel → DD/MM/YYYY
   • Universal / safest → YYYY-MM-DD (ISO); Excel parses this regardless of regional setting
3. Download the file and open it.

Still seeing NaN after changing format

If dates remain as text even in ISO format:

• Select the Date column → Data → Text to Columns → Finish. This forces Excel to re-parse the column.
• Or select the cells, right-click → Format Cells → Date → pick a format.

Avoiding it next time

Set your default export date format to YYYY-MM-DD in your account Profile settings, under Date Format. This becomes the default for future downloads (it's shared across everyone on your contract).

See Customize date format for per-download, per-profile, and per-project overrides.

Related

• Customize date format
• Correcting the year
• Downloading bank transactions