Skip to main content
R
robmerkin@mail.com
Participant
October 22, 2019
Question

Converting .pdf to Excel: Conversion changes meaning of decimal point.

  • October 22, 2019
  • 2 replies
  • 346 views

I have .pdf documents that consist of tables with columns, one of which contains lists of locations by time.  The format is hours:minutes:seconds.hundredths of a second (0:00:00.00), but when I convert the document to Excel, the last element of the format becomes thousandths of a second.  For instance, 4.34 seconds (0:00:04.34) is interpreted as 4.034 seconds, so the cell in Excel displays 4.03 (0:00:04.03).  

 

I have searched and searched, but cannot find a way to correct for this before converting.  Anyone have an idea?  

    This topic has been closed for replies.

    2 replies

    A
    Adobe Employee
    akagarg17099634
    Adobe Employee
    December 9, 2019

    Hi Robmerkin,

     

    Thank you for your patience. This is the issue with excel default formatting. You can change the formatting of cell using following steps:

    1. Select the cell which contains the time string
    2. Press Ctrl+1 (on win), this will bring up cell formatting dialog
    3. Make sure tab 'Number' is selected. Now select 'Custom' as category and type 'h:mm:ss.000' in 'Type:' input box.
    4. Press ok. This will change the time string to expected value.

     

    Hope this solves your problem.

     

    Thanks and Regards,

    Akanksha Garg

    Adobe Acrobat Team

     

    A
    Adobe Employee
    akagarg17099634
    Adobe Employee
    October 23, 2019

    Hi Robmerkin,

     

    Thank you for reporting the issue. I am forwarding this issue to the engineering team.

    We will get back to you on this as soon as we have a solution handy.

    Thanks for your patience!

     

    Regards,

    Akanksha Garg

    Adobe Acrobat Team

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices