Custom characters coming out wrong

[mikewohlwend]

I am trying to create a custom number under the format cells window and 30 doesn't work for me.

Does anyone know what is causing this to happen?

 

[awoohaw]

Is this conditional format or custom number format?

But, either way, try this custom number format:

3\0

 

[mikewohlwend]

That worked. Thank you.

 

[awoohaw]

happy to help. Best wishes!