Excel file to Indesign

[Marte15A9]

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?

[Jeffrey_Smith]

This sounds more of an Excel issue than an Indesign issue. Here is an article that shows an option to try in Excel.

[Marte15A9]

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. 

[Jeffrey_Smith]

What is the format of the cells with commas (13,4)?

[Marte15A9]

Custom format. 

[Jeffrey_Smith]

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.