I need to put dollar values into narrow columns in excel.
If I format it as general or currency, it tuns into "##" in the cell
and doesn't go over the cell boundary.
Only if I format it as text and manually add the "$" then it extends
over the cell boundary.
I am using excel 2000.

Any way around this?

TIA