Can this be done?
I want to format cells to 2 decimal places and also to a percentage. It needs to happen automatically as the report is refreshed rather than having to make this change manually.
Thanks
Alan
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello Alan,
When you refresh your report, it will automatically use the default table settings you have in Excel. This means that if you change the color, format columns, etc, the next time you run the report, those changes will be overwritten with the default table settings. :( -
Jet Reports Historic Posts You can get around the color and basic font settings by setting that as the default table for that workbook - but I've not seen a way to make a table accept particular number formatting for a certain column as part of it's default setting.
Can you use the Excel ROUND formula to set the decimal points? The percentage is a bit more tricky - if you just need it to appear as a percentage (not be functional as one), then adding the "%" to the end as part of a text function might work.
I don't work in tables often, so I'd have to play around to see exactly how this would work - but I think you would have to retrieve the number you want in one cell, then use the FORMULA option to convert the number. -
Jet Reports Historic Posts Or create a Pivot Table & use the formatting in this as this is what I have done before
Please sign in to leave a comment.