dollar amounts

hello. my name is paul and i am doing a simple program on accounts due and would like to make negitive dollar amounts invisable. i know how to make numbers invisable however the code i put in the custom area turns everything into regular number and i want them still to be dollar amounts. hope that makes sense. i am an older person. when in high school they were just inventing calculators so be easy on me. thank you in advance
paul

You can use a custom format for the cells. Select the cells, then use the format dialog, select "Custom" at the bottom of the list on the left and enter this:

$0.00;;$0.00;@

wow thank you that was fast. worked like a charm. another question is their a way to make negative dollar amounts say paid? by the way what a great forum

thank you! worked perfect, i am pig headed and have spent days trying to figure this out and you all showed me in minutes. your help is truley apreciated

i had it that way originally and the people that had to read it were confused. seemed simple enough to me but you know how it is sometimes lol
what you showed me made it perfect for the average person. and i can just print and hang it up for them to look at. thank you again everyone