Thanks for the help, however, I tried the auto correct feature, but found
whenever I typed the letter y the word yes would appear. If the event macro
would prevent this from happening that would be great!
- jhardw

"Otto Moehrbach" wrote:

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.