Formatting Columns

W

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?
 
V

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
 
W

wg100

vezerid said:
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
Click to expand...


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