Hi
Not Directly !......but you can use the UPPER function.
If your data is in A1, put =UPPER(A1) in A2.
This will convet whatever you type in A1 to Uppercase in A2

HTH
Michael

"WAF" wrote:

Is there any way to format a cell so that text entered will always display in
caps?