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
------------------------------------------------------------------------
skeetley's Profile: http://www.excelforum.com/member.php...fo&userid=4122
View this thread: http://www.excelforum.com/showthread...hreadid=478150

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


--
skeetley
------------------------------------------------------------------------
skeetley's Profile: http://www.excelforum.com/member.php...fo&userid=4122
View this thread: http://www.excelforum.com/showthread...hreadid=478150