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]”N...

Resources