Try this from the current cell:

IF(A1=1,"YES",IF(A1=0,"NO",))



"wg100" wrote:


I want to format a column so that if I enter 1, or 0, then the cell in
that column that I am editing will then show the word Yes or No. Is
this possible?


--
wg100
------------------------------------------------------------------------
wg100's Profile: http://www.excelforum.com/member.php...o&userid=28330
View this thread: http://www.excelforum.com/showthread...hreadid=479123