I'm trying to format numbers in an InDesign table that I imported from Excel (File-->Place...--->Table: Formatted Table". The Excel file has several columns with a custom format ".000". This displays as expected in Excel (i.e., 0.000 displays as .000) but when I place the Excel worksheet in a table in InDesign it appears as "0.000".
InDesign preserves the Excel format for cells that have a non-zero value (i.e., .092 appears in InDesign as .092) but wherever the value is .000 in Excel, InDesign adds a leading zero (0.000).
I've got a ton of tables to create for this document and would prefer not to have to hit each cell and delete the leading 0.
Any tips on how I can achieve this?