Number Format "Yes";"Yes";"No" No Longer Works With TRUE/FALSE values

Question

_{Wednesday, September 18, 2013 3:48 PM}

In Excel 2003, I used the Number Format '"Yes";"Yes";"No"' to change the way a True/False value was displayed. Now that we have converted to 2010, that number format is not working. I need this to be done in the NUMBER FORMAT, NOT in an additional formula in another cell.

All replies (5)

_{Friday, September 20, 2013 4:41 AM ✅Answered}

Hi,

Based on my research, Number Format adds some new functions between Excel2010 and Excel 2003.

We can custom Number Format easylier and find the feature in Robbon.

I recommend we checkt the Number Format iN Excel 2010, Please refer to the below link:

Excel 2010:http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx

Excel 2003:http://office.microsoft.com/en-us/excel-help/number-format-codes-HP005198679.aspx

Regards,

George Zhao
TechNet Community Support

_{Thursday, October 9, 2014 5:05 AM}

I've found a solution to this - I've used conditional formatting to achieve this.

Set 2 conditions - one when the value is equal to TRUE, the other for FALSE.

For TRUE, set the formatting to Custom number format ;;;"Yes" and for FALSE, set it to ;;;"No".

True/False seem to be evaluated as text/strings in the custom number formatting sequence.

I hope this (belatedly) helps.

_{Tuesday, September 20, 2016 12:49 AM}

Brilliant work-around! Thanks!

_{Wednesday, June 21, 2017 10:11 AM}

Please send a complete expression

Rabelani Netshifhire