How to Fix Decimal Seconds Formatting When Converting PDF to Excel
Question details
The user needs to correct the display of fractional or decimal seconds after converting a PDF table containing time values into an Excel spreadsheet.
- Product
- PDF to Excel Converter
- Device & OS
- Windows
- Scenario
- Converting PDF tables that contain precise time data (such as 0:00:04.34) into Excel format.
- Observed behavior
- Time values with hundredths of a second are displayed as thousandths or rounded incorrectly due to default spreadsheet cell formatting.
Click on the affected cell and check the formula bar to ensure the underlying time data was successfully preserved during the conversion before adjusting the display format.
Adjust Custom Cell Formatting for Time Values
Change the default cell format to a custom time format that accurately displays fractional seconds.
Spreadsheet programs often apply a default time format that does not account for fractional seconds. By customizing the number format, you can instruct the software to display the exact hundredths or thousandths of a second as they originally appeared in the PDF.
Highlight the cell or range of cells in your spreadsheet that contain the incorrectly formatted time values.
Press Ctrl+1 on your Windows keyboard, or right-click the selected cells and choose 'Format Cells' from the context menu.
In the Format Cells dialog box, make sure the 'Number' tab is selected, then choose 'Custom' from the Category list on the left.
In the 'Type' field, enter h:mm:ss.000 (for thousandths) or h:mm:ss.00 (for hundredths), then click OK to apply the changes.
Convert PDFs to Excel Accurately with WPS Office
WPS Office provides a highly accurate PDF to Excel conversion tool that preserves original table formatting and complex data structures, minimizing the need for manual data correction after conversion.
- 1. Open the PDF tool: Launch WPS Office and navigate to the 'PDF' tab on the main interface.
- 2. Select PDF to Excel: Click on the 'PDF to Excel' feature located in the top toolbar.
- 3. Convert the document: Add your PDF file, specify the language if necessary for better accuracy, and click 'Start' to convert.
- 4. Format data seamlessly: Open the newly created spreadsheet in WPS Spreadsheets and use the Ctrl+1 shortcut to instantly adjust any custom time formats.
Frequently Asked Questions
Why does my spreadsheet change the PDF time values upon conversion?
Spreadsheet software automatically applies default number formatting to recognized time values. If the default format doesn't include fractional seconds, it visually rounds the display, even though the underlying data usually remains intact.
How do I show hundredths of a second instead of thousandths?
In the Format Cells dialog under the Custom category, use the format code h:mm:ss.00 instead of h:mm:ss.000 to display exactly two decimal places.
Does the underlying data get lost during the formatting change?
No, changing the custom cell format only affects how the time is displayed visually. The actual underlying data is preserved in the cell's memory.
What if the time value is recognized as text after conversion?
If the converted time is treated as text, the custom formatting will not apply. You will need to use the 'Value' function or the 'Text to Columns' feature to convert the text back into recognizable numerical time data first.
