Left align '$' and right align numbers?

[skeetley]

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

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

Also, I want to put 1-99 in a cell. It keeps going to January 1999.
changed the cell to 'text' and it keeps 1-99 in there. Is this the bes
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.