Hi! I have an Excel file that I have connected to Indesign. The format is somewhat changing, eg. color is correct on some tables while others are not. In addition, my main question is: We have changed the format from 13,5 to 13.5 in Excel but when we import it to Indesign, it only says 13,5. Do you know how to change this?
I have done this in Excel, however this does not translate to the format as in Excel to Indesign. Hence, the 13,4 shows in Indesign although I have changed it to 13.4 in Excel.
What is the format of the cells with commas (13,4)?
In Excel, do you need to retain the format with comma for any reason? If not, change to General or Text format for the column.