Many of my Q&A reports used derived columns.  As an example, my "Monthly Billed" report has a column called Running_Total which shows a value that adds itself to the amount of each invoice, and a Needed_To_Tie column which subtracts this value from the amount of last year's total billing in the same month.

However, after translation, both these columns are formatted as Text, which breaks the programming because it's trying to do math on them (type mismatch error).

I can't seem to find a way to change this format to money.  The Property Editor will only allow me to do Text formatting on it (uppercase or lower case).  Is there a step I'm missing?

Yep, that did it, thank you.