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?
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.