Left align '$' and right align numbers?

[skeetley]

Hi, I tried searching for an answer to this myself, but "left right align $" yields nothing useful to me.

So I have seen spreadsheets where the $ is left aligned in the cell and the dollar amount is right aligned. How do I do this? I tried formatting the cell in all types of different coutnries currencies but that didn't do the trick. I assume it is somewhere in the cell formatting, but I can't find it.

Also, I want to put 1-99 in a cell. It keeps going to January 1999. I changed the cell to 'text' and it keeps 1-99 in there. Is this the best way?

Many, many thanks.

[skeetley]

Ah i finally figured it out. In case anyone else comes along with the same problem, you chose "accounting" under format cells.