DocuClipper Logo White

Dates Shows as Nan in Excel

If you see that dates in excel show Nan, you can customize the date format and download it again.

Steps to Customize Date Format #

  1. Start the Download Process: Initiate the process of downloading the file from DocuClipper.
  2. Access the Dropdown Menu: As you proceed with the download, you will encounter a dropdown menu. This menu allows you to modify the date format.
  3. Select Your Preferred Date Format: From the dropdown menu, select your preferred date format. For instance, you can choose the DD/MM/YYYY format.
docuclipper wrong date in excel

Video Tutorial #

For a more detailed guide, you can watch our video tutorial on how to download data and customize the output format with DocuClipper. The video provides a step-by-step walkthrough of the process, making it easier for you to understand and apply.

Conclusion #

Customizing the date format in DocuClipper is a straightforward process. With just a few clicks, you can set your preferred date format and ensure your data is presented exactly how you want it. If you encounter any issues, feel free to reach out to our support team for assistance.

Was this article helpful?
Updated on August 7, 2023
DocuClipper Get Started Free

Get 2,000 Pages
for Free

See for yourself how DocuClipper can convert your bank statements in seconds without any manual input. Learn how it will save time, increase accuracy, and help provide a superior service for your customers or clients.