All Comments

You have to change the format...right click on the cell and change the format to custom and pick the correct option..forget the one it is and I dont have Excel loaded on home PC...so cant remember the exact one for you to pick

question is why do you want to do this, if u want to do it for a label then text will do, if you want to perform math on this cell then it's not advised.
but then again if you want to perform math on this cell why would you want to show a 0