How to Align $ to the left in Reporting Tool

Question

I am trying to align the dollar sign to the left of the cell while keeping the actual amounts to the right of the cell in the reporting tool. Every way I have tried before aligns all the data to the left including the amount. How do I only get the dollar sign to stay on the left? Thanks

ecotton · Answer

Unfortunately I do need to use the reporting tool. Thank you so much for the suggestion though!

FilipR · Answer

Unfortunately I don't think that is possible to do. Even if you select Preserve Formatting, the rows inserted by Alteryx revert to the General format, and if you add a dollar sign in Alteryx, you will get a string inserted into Excel instead of a numeric value.

MichelleL · Answer

@ecotton I don't see an option in the Table tool to have the $ sign at the left and the numbers at the right.  If you don't have to use the reporting tool, another option is to format your Excel spreadsheet with the needed formatting and then use an Output tool with the configuration set to 'Preserve Formatting on Overwrite'.