View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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
...