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.

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.