3 Replies Latest reply on Jan 23, 2017 9:05 AM by PJL41

    Acrobat Xi "Find" & "Replace" discussion.

    PJL41

      My credit card statements come with dates in the format "dd/mm/yy".

      I ultimately want the transactions to be saved as an access data base file.

      To do this I export the cropped PDF transactions to an XLSX file.

      However XL interprets the dates as YY/MM/dd.

      The solution is to "find and replace" the dates in the PDF transactions as dd/mm/yyyy.

      However when I type "/16" into the find box it finds nothing because the greyed out, prechecked "find whole words only" cannot be unchecked.

      Tried full acrobat search which works fine - but there is nowhere to replace wit "/2016".

      I would appreciate some help if someone has an answer