Microsoft Excel Tip - changing 1 and 0's to Yes and No's

Instead of using 1s and 0s, you can use"yes" and "no" in your column.  Format the column and select number tab, then go to custom format and use the following in the type field: "yes";"";"no". Now when you type 1 in a cell it will show "yes" and when you type 0 it shows "no".

Yahoo Answers