View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Format cell to accept only specific character-reject others

Try this:

Select the impacted cells
DataData Validation
Allow: List
Source: F,H
Click [OK]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"aetzkin" wrote:

I am trying to format a cell so that it will only accept the characters H or
F and reject all others.