I have an InDesign CS5 document with 100+ tables that are linked to Excel spreadsheets so every quarter I just need to update the links instead of recreating the document again. My issue that it appears that InDesign is not rounding off a number correctly. Then number in Excel is 0.945. When I format the number in Excel to 2 decimal places, it displays the number as 0.95. When the number is imported into the InDesign document, it displays it as 0.94. If I change the number in Excel to 0.946, InDesign will then round the number correctly to 0.95. It seems to only happen when the least significant digit is a 5.
With out going through all 100+ Excel Worksheets, how can I get InDesign to correctly display this number?
I seem to remember this being discussed in the past. What I don't
remember is whether or not there was any resolution to it.
I think the resolution was to convert the cell format to text. But...that was past yesterday, which is far back as my memory goes.
Interesting. Since I never knew that Excel sheets can be placed as is, I placed some Excel sheet and set a number of 1.345 into a cell and formatted to two decimal places, then showing as 1.35.
Then imported to ID via extended dialog and set like "decimal places = 2" and it rounded it to 1.35. This is expected and so it actually works.
The only difference to you is, I got CS6.