Formatting cell to properly display % as 0%

[Oryan77]

I have my sheet set to "Show a zero in cells that have zero value".

I am trying to format a cell so that it displays % in a cell when numbers are entered, such as, 0%, 5%, 10%, 20%, or 50%.

I used the formula ##\% in the custom cell format, which works for all numbers except for when a zero is entered as a value. The cell only shows the % rather than showing 0%.

I have other cells that reference this cell using IF(ISNUMBER(SEARCH formulas. So I need the cell to show exactly as 0%, 5%, 10%, 20%, or 50%. The % does not actually need to be a value after the number. I just need the cell to display the % after the number.

Is there a way to make this work without breaking my other formulas?

 

[jtakw]

Hi,

You can use:

0\% as the custom format, but you do realize the underlying Value is the Whole number 5, 10, 20, etc, and Not .05 (5%), .1 (10%), .2 (20%)...

 

[Oryan77]

That was it. Thank you. I knew I was doing something stupid.

 

[jtakw]

You're welcome.