Formatting Columns

[wg100]

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?

 

[Guest]

Try this from the current cell:

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

 

[vezerid]

If you want the cell itself to display yes/no when 1/0 is entered, you
can try the following:
Format|Cells... | Number tab. Select custom format and use:
"yes";;"no"

HTH
Kostis Vezerides

 

[wg100]

If you want the cell itself to display yes/no when 1/0 is entered, you
can try the following:
Format|Cells... | Number tab. Select custom format and use:
"yes";;"no"

HTH
Kostis Vezerides

Thanks, that was just the answer I was looking for.