View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] goldcomac@mac.com is offline
external usenet poster
 
Posts: 30
Default Forcing an entry

I swear I've done it before, but I can't remember how.

Can't I force a cell to take a Y or N as opposed to a number (or any
other character, for that matter)? Also, can I guarantee that the Y or
N is capitolized?

Thank you.

Chip