Jaime de Vos wrote:
As you can see, I'm not quite sure how to phrase this question, so I translated it rather literally from Dutch. But I digress...
I'm currently working on a price list for our sales organisation, and they've given me prices that are formatted as shown below.
What I need to do is find two decimal numbers, remove them and round up the price, or when the decimal numbers are ",00", then I merely need to remove the ",00".
Is there a GREP or Script that can help me out with this, because I really shudder at the thought of having the redo all those prices.
Need to look like this;
Alternatively, numbers that are formatted like this,
Need to look lis this;
I hope I explained my problem in a clear manner. If I haven't, please don't hesitate to let me know!
Thanks in advance, everyone.
I don't know if GREP can do this.
Search Google for terms like "indesign round numbers script" without quotes for some leads.
Also, dtptools.com's Active Tables plug-in for InDesign works like a spreadsheet, so you can define formats and formulas for cells. There's a ROUND function. I'm not sure there's a numeric display format that supresses the decimal point and trailing zeros. You can experiment with the trial, or ask their tech support - it's very prompt, allowing for time differences across the globe.
No you can't do this with GREP.
Thanks for that, I'll look into the script functions.