I have a table in *.xlsx format, it contains several dates in the format 2013-12-31. When I place the document into my InDesign-file, the date format changes to 2013/12/31. How can I fix this?
I have tried setting the cell formating of dates in the Excel-file to the correct format, which also shows correctly when in Excel, but it still changes when placed in InDesign.
@Devoteez – it should work, if you format all cells in Excel as "Text" before placing in InDesign.