3 Replies Latest reply: Feb 20, 2014 3:11 AM by F. Arabak RSS

Left Justify Dollar Symbol in Columns

F. Arabak Newbie
Currently Being Moderated

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:


"$        100"

"$     1,000"

"$   10,000"




  • Correct Answers - 10 points
  • Helpful Answers - 5 points