The date formating is wrong when converting an Excel file

Question:
I am converting an Excel file to PDF and dates are formatted differently from the resulting PDF file. How do I correct this?

Answer:
The formatting of the dates in Excel is based on locale. By default, PDFNet uses the locale of the host system when doing the conversion. However, if you need your date to be formatted in a different manner, you can use the following method to change the locale: