How to Align $ to the left in Reporting Tool

[ecotton]

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 

[binuacs]

@ecotton I think the table treat $amount as one field and at a time you can align left, canter or right.

[ecotton]

I am trying to output to an excel sheet with the reporting tool and it will not keep that same format where the dollar sign is left and the amount is to the right. 

[MichelleL]

@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'.  

[FilipR]

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.

[ecotton]

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