I generate a report using python that has a column of rates. These rates used to be just floats that I would convert using the number formatter on excel to currency and use that column for a pivot table. I wanted to automate this for the future so less manual work would be needed and also didn’t want to use VBA since if I have to handoff this report the next person might not know VBA. I also know that with how the pivot tables need to look, I cannot generate them from python and need to manually generate them from excel. This will not change.