Auto-Format Capitalizing
It is surely not. You can do it with VBA though. Put this in the worksheet
module:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
For Each cel In Target
If cel.Column = 2 Then
If cel.Formula < UCase$(cel.Formula) Then _
cel.Formula = UCase$(cel.Formula)
End If
Next
End Sub
HTH. Best wishes Harald
"Meesheltx" skrev i melding
...
I want one column in my spreadsheet to ALWAYS be capitalized. Surely
there
is a simple way to do this. Does anyone know of one?
|