Sorry about that! I'll change the description. Replacing the blank with a hyphen doesn't work. If I format all those cells to currency, that does cause a 0 to display as you indicated and when I do change the "" to include 0, it actually does work. But, I am wondering why it's not working with the hyphen? (I got the hyphen formating the cell and using the custom function to input the hyphen)

Also, How do you change the wording on the button from "commandbutton1" to something else?