Forum Discussion
KevinWillyerd
Aug 28, 2021Copper Contributor
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.