Text Restrictions
 

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

Text Restrictions
 

=EXACT(C11,UPPER(C11))
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"LPS"
wrote in message
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

Text Restrictions
 

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

Text Restrictions
 

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