Skip to main content
Participant
August 3, 2016
Question

Export to Excel - some dates (dd-mmm-yyyy) turn negative

  • August 3, 2016
  • 1 reply
  • 259 views

I am trialling Adobe Acrobat DC, with a particular interest in exporting tables in pdf documents to Excel to facilitate searching and filtering on the data.

The dates are in the format dd-mmm-yyyy  e.g. 12-Nov-1797.

Many of the dates show up correctly in Excel but just as many are converted to a negative  number which shows up in Excel as a string of #.

In one document, the dates not converting are left justified and those converting correctly are right justified but in another there is no apparent logic.

I have a workaround, exporting to html and then importing the result into Excel.

I tried another product PDFElement (which allows 2 page conversion as a trial) and that converted ok.

I think there is a bug in the Adobe product and probably a fairly simple one, but I have not been able to find any way to report it!

This topic has been closed for replies.

1 reply

rgdobieAuthor
Participant
August 3, 2016

Further to this:

An example is a date that was 3-Jan-1813 in the pdf that was translated in the Excel  as -31772

    In Excel's Visual Basic Immediate window we can type:

?format(-31772,"Long Date")

     and get the result:

Sunday, 3 January 1813

which is correct!