I have cells with text in all caps. I can change them to Proper
formatting by using:

[B1] = Proper(A1)

and then copying B back over top of A and then finally erasing B.

Is there some way however to tell Excel to simply format the cell using
the rules for Proper()? I've tried playing with the Custom format, but
haven't stumbled into any syntax that seems to work for it. I don't
really care if the text itself is actually changed to Proper format as
long as it's displayed as such.

If necessary I can write a macro to do it, but it struck me as something
that might be already built into some dark corner of Excel.

Thanks....

Bill