How to format a $ sign into a blank cell?

[mt011]

I know this may be a really simple question, but here goes. I want to insert a $ sign in a range of cells that are blank (""). I know how to do this from a zero value with out the zero displaying, but can not figure out the blank?

Thanks

 

[Cam]

Highlight your range of cells. Go to "edit" then "replace" leave the "find" line empty and in the replace line insert $, select replace all.

 

[mt011]

I guess I did not do a good job wording my question. These cells have formulas in them. If the result of a formula is >0, it returns a $00.00, and <0 a red $00.00. I want to display the $ in all cells until data is entered.

 

[mt011]

Certainly, someone can tackle this simple question? Or is it just not possible to format the cells (with a formula) that are blank with a dollar $?

 

[lenze]

What is your Formula?

 

[Dave Patton]

On 2002-08-30 11:01, lenze wrote:
What is your Formula?

If we knew your formula, we could probably provide a better answer.

consider

=IF(B2>10,1,"$")

 

[mt011]

I was thinking there was a feature or command in the Format Cells under the custom category. However, the formula I have in the cell is:
=if('sheet1!D10="",0,'sheet1'!D10)

Thanks for your help!