I have a very large excel table with a lot of large numbers that are rounded to the million that I am placing in InDesign. When I place the file formatted, it crashes InDesign. So I bring it in unformatted and I loose the rounded numbers and I can't fit the table on the page. How can I create a character style or GREP that enables me to round $12,000,000.00 to $12M?
I believe there's a setting in Excel that allows you to change the data to "as displayed" so you could try that on a copy of the spreadsheet.
I found an option in Excel, under advanced, about calculations 'Set Precision as displayed'. I tried that in several ways, with no luck. Any other ideas?