One way is to setup the AutoCorrect feature of Excel. Setup AutoCorrect to
substitute Yes for y and for Y. Same for No. AutoCorrect is accessed with
Tools - AutoCorrect Options.
Another way is to use an event macro to do it. Post back if you want an
event macro. HTH Otto
"jhardw" wrote in message
...
I want to type the letter Y or N and the word yes or no to appear in the
cell.