Not really! I woyuld use data validation to force them to put X in the cell,
or post process then input in a hidden column to the left.

Formatting can make anything show as X but it will not have the value X

"Randy" wrote:

Hello, I have a question pertaining to forcing particular cells into
uppercase text. I have about six cells, all in different rows & columns, that
will have an "x" typed into the cell. I need this "x" to auto-convert to an
uppercase "X". Is there an easy way to do this?

Also, was wondering if there is a way to make these cells automatically
place an uppercase "X" in the cell no matter what letter, number or
charachter the users type? Example, if a user types an "a" or a "c" into the
cell it will automatically convert to an Uppercase "X"...

Any assistance will be greatly appreciated.

I thank you in advance for your time!

--
Randy Street
Rancho Cucamonga, CA