Displaying a zero percentage in a single cell

[sbuck]

OK - I will try to explain a little better this time:

My Excel 2007 worksheet contains a cell where a percentage is manually input. A freight cost is calculated based on the input percentage. Typically, the percentage is 3-7% but once in a while freight is excluded and the percentage is zero.

My issue is that when a 0 is input the cell appears blank and I would like it to display 0.00%. The remainder of the worksheet needs to have the zero display turned off.

Please let me know if you have any solutions.

sbuck

</SPAN>
</SPAN>		</SPAN>
</SPAN>	</SPAN>	</SPAN>
</SPAN>	</SPAN>	</SPAN>
</SPAN>	</SPAN>	</SPAN>
</SPAN>	</SPAN>	</SPAN>
</SPAN>		</SPAN>
</SPAN>		</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=4></COLGROUP>

 

[BenMiller]

Right-click on that cell. Click Format cells. Choose Percentage. Choose 2 decimal places. Click OK.

 

[sbuck]

Thanks but that displays all numbers except zero. When zero is input - the cell shows nothing (blank).

 

[shg]

In Excel Options > Advanced, Display options for this worksheet, tick Show a zero in cells that have zero value

In cells on that same sheet where you don't want zeroes to appear, format them appropriately, e.g, General;General;;