How do I format a 1 to dispay as "yes" and a 0 to display as "no"
 

I have a colum with 1s and 0s I want to display the cells with 1 as a Yes and
the ones with 0 as a no. How do I do that?
Help

How do I format a 1 to dispay as "yes" and a 0 to display as "no"
 

Try this:

Select the cells to be impacted.
Ctrl+1.......a shortcut for <format<cells
Select the Number tab
Category: Custom
Type: "Yes";"Yes";"No"
Click [OK]

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"fontanafratta" wrote in message
...
I have a colum with 1s and 0s I want to display the cells with 1 as a Yes
and
the ones with 0 as a no. How do I do that?
Help