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.

I tried using the formatter .map('${:,.2f}'.format) but this causes the values to be identical to string values. When I use this formatter, I have to highlight the values, convert to number, then convert to currency. I pretty much causing myself more work.