7 Replies Latest reply on Sep 30, 2015 2:44 PM by rkettenaz

    Rounding numbers to the million with dollar sign in InDesign

    rkettenaz Level 1

      I have been struggling with this problem for over a year now and I need to start asking some experts. I have several large excel files that have lots of large numbers ($millions) and I need to scale them down to fit into smaller cells by rounding to the nearest millionth in InDesign CC. So instead of $23,564,950.00 I need $23.6M. The formatted version of the import doesn't carry over the format. Is it possible to wright a script for this? I haven't found a way to do this with styles.