Linked Spreadsheet Issue: Percentages Not Showing Decimal Values

[#1]

Hiya! I'm experimenting with linking tables to an Excel document and running into an issue with percentages. There is a column of data that is formatted in Excel as percentages with two places after the decimal (e.g. 24.50%), but when I place the linked sheet into InDesign, the percentage values are not showing anything after the decimal. Is this a bug, or there just some setting that I'm missing? I have tried saving the Excel spreadsheet as .xls, but that did not solve the issue. I have also updated to the latest version of InDesign (16.0.1), and that didn't help.

Any thoughts? Thanks.

[#2]

Hiya! I'm experimenting with linking tables to an Excel document and running into an issue with percentages. There is a column of data that is formatted in Excel as percentages with two places after the decimal (e.g. 24.50%), but when I place the linked sheet into InDesign, the percentage values are not showing anything after the decimal. Is this a bug, or there just some setting that I'm missing? I have tried saving the Excel spreadsheet as .xls, but that did not solve the issue. I have also updated to the latest version of InDesign (16.0.1), and that didn't help.

Any thoughts? Thanks.

[#3 · Accepted solution]

Not sure how to delete a post, but I literally figured this out right after posting. There is a "number of decimal places" field in the Place dialogue where I can set that. Screenshot attached for reference, in case anyone else has this question.