3 Replies Latest reply on Nov 12, 2013 8:53 AM by Doc Maik

    Problem with excel numbers

    dspanburg

      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?