Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
This sounds more of an Excel issue than an Indesign issue. Here is an article that shows an option to try in Excel.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
What is the format of the cells with commas (13,4)?
Copy link to clipboard
Copied
Custom format.
Copy link to clipboard
Copied
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.