Forum Discussion

KevinWillyerd's avatar
KevinWillyerd
Copper Contributor
Aug 28, 2021

Microsoft 365 Custom number format fo Yes No

I want to create a custom number format in Excel for Microsoft 365. If I type 1 I want it to display "Yes", 0 displays "No" and anything else "Invalid". I tried several formulas like [=1]”Yes”;[=0]”No”;”Invalid”  but I get an error box "try using one of the built-in formats. Best I can tell it is formatted correctly.

Resources