I had asked this question previously in the wrong forum so I'm posting it here.
I am not seeing how to justify symbols to the left or right. For instance, instead of "$100", I want to left justify the dollar symbol to "$ 100" such that all of the dollar symbols line up in a columns. I followed the suggestion to Right click the column -> format -> in "Number" tab, write $ then space in the prefix field. But this yields a space between the symbol and the number but doesn't line them up:
" $ 100"
" $ 1,000"
" $ 10,000"
I would like to left justify the $ to the same place in each row: