| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
| Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
