Excel 2007 : Display zero percentage in a single cell

**sbuck** · 06-25-2012, 03:48 PM

All,

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

**Cutter** · 06-25-2012, 04:04 PM

You could apply a custom format to that cell:

0.00%;;"0.00%"

**Taislin** · 06-25-2012, 04:05 PM

A custom format is an option. Also you can try this: =IF(A1=0;"0,00%";A1) where A1 is the ceel where you input the data.

**sbuck** · 06-25-2012, 04:11 PM

Thanks very much - I appreciate your help.

**Cutter** · 06-25-2012, 04:29 PM

You're welcome. If your question has been resolved please remember to mark your thread as SOLVED (see instructions in rule #9 by clicking Forum Rules button @ top of page).