I exported a PDF file from Adobe Acrobat. One of the columns was a date expressed as dd/mm/yy. Excel interpreted this import as yyyy/mm/dd.

So I tried a Find and Replace in the PDF file with Find as /14, and intended to replace it with /2014; but no sooner as I opened the replace field the "whole word only" geyed out and pre-checked the field (therefore not allowing me to check search for part of a word)

Any help would be greatly appreciated.

Patrick Lyons

PJL1941@gmail.com