Thank you Ron. That does, indeed help.

Cheers,
--
LPS


"Ron Coderre" wrote:

Try this:

Select cell A1

From the Excel main menu:
<data<validation<settings tab
Allow: custom
Formula: =EXACT(A1,"X")
(Adjust the Error Alert so it mentions that only uppercase "X" is allowed)
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"LPS" wrote:

Using Excel 2000 and without having to get into Macros, is there a way to set
a validation such that only an uppercase character can be enterted into the
cell? For example, the cell would allow an uppercase "X" but nothing else?

Thank you for all help / suggestions,
--
LPS