1 Reply Latest reply on Mar 22, 2017 10:30 AM by sb116

    export PDf to excel but date format changed

    kennethkong

      Using Acrobat X Pro. 

       

      Export a list of customer with date of account opened.  After converted to Excel, the date of account opened format changed.  Originally is in MM/DD/YYYY format in PDF. After conversion, when the DD is less than ten, the MM and DD will interchanged.  For example, originally is Feb, 4, 2016 02/04/2016, after conversion, it becomes 04/02/2016.

       

      Is there a way to get around.  Without this, it is difficult to do a sorting by the date of account opened.

       

      Thanks.

       

      Kenneth