vezerid Wrote:
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.
--
wg100
------------------------------------------------------------------------
wg100's Profile:
http://www.excelforum.com/member.php...o&userid=28330
View this thread:
http://www.excelforum.com/showthread...hreadid=479123