Try pressing the key below Esc while holding down CTRL. This toggles show
formulas/results.

HTH,
Andy

Try this macro:
Copy the macro below
Press Alt+f11
A module will appear
Paste the macro below
Highlight range of cells you want to convert to proper case
run macro

Sub Proper_CASE()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = StrConv(Rng.Value, vbProperCase)
End If
Next Rng
End Sub


>-----Original Message-----
>Try pressing the key below Esc while holding down CTRL.
This toggles show
>formulas/results.
>
>HTH,
>Andy
>
>
>.
>