Thread: How do I format a 1 to dispay as "yes" and a 0 to display as "no"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default 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 With QuoteReply With Quote