Is there a font that shows a Y as a tick and an N as a cross?
You could use (insert) another column alongside the input column, and have
that "helper" column display those characters.
Say the Y and N is entered in Column G.
Format Column H to "WingDings 2",
Then enter this formula in H1:
=IF(G1="N",CHAR(200),IF(G1="Y",CHAR(80),""))
And copy down as needed.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"julie cooke" wrote in message
...
|