Forrmat as captials
 

When a user enters data into a cell in lowercase how can that data then be
converted to uppercase.

Thanks
Pat

Pat,

In an other cell

=UPPER(A1)

--
HTH

Bob Phillips

"Pat" wrote in message
...
When a user enters data into a cell in lowercase how can that data then be
converted to uppercase.

Thanks
Pat