Is there a way to format cells containing text in all caps so that they are
not in all caps?

=LOWER(A1)

"Taylor" wrote:

Is there a way to format cells containing text in all caps so that they are
not in all caps?

Is there a way to do it without having to insert an additional column?

"Dennis" wrote:

=LOWER(A1)

"Taylor" wrote:

Is there a way to format cells containing text in all caps so that they are
not in all caps?

LOWER, PROPER ?
But not by formatting.
--
David Biddulph

"Taylor" wrote in message
...
Is there a way to format cells containing text in all caps so that they
are
not in all caps?

Copy the new column and then paste Special values only into your exsiting
column and then delete the additional column

"Taylor" wrote:

Is there a way to do it without having to insert an additional column?

"Dennis" wrote:

=LOWER(A1)

"Taylor" wrote:

Is there a way to format cells containing text in all caps so that they are
not in all caps?

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Lower()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = LCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:28:01 -0700, Taylor
wrote:

Is there a way to do it without having to insert an additional column?

"Dennis" wrote:

=LOWER(A1)

"Taylor" wrote:

Is there a way to format cells containing text in all caps so that they are
not in all caps?

Taylor wrote:
Is there a way to format cells containing text in all caps so that they are
not in all caps?
You could download an all lower-case font.
See http://www.fontcenter.com/categories...nly/index.html

Bill

"Bill Sharpe" skrev i melding
...
Taylor wrote:
Is there a way to format cells containing text in all caps so that they
are not in all caps?
You could download an all lower-case font.
See http://www.fontcenter.com/categories...nly/index.html

What a concept, Bill. We all think it can't be done by formatting, but this
is it, way outside the box. Thanks!!!

Best wishes Harald

Fine as far as it goes, but remember that in such situations a
case-sensitive comparison with the lower case alternative would presumably
not succeed. You are presumably just seeing the upper case letters
*displayed* the same as lower case.
--
David Biddulph

"Harald Staff" wrote in message
...

What a concept, Bill. We all think it can't be done by formatting, but
this is it, way outside the box. Thanks!!!

"Bill Sharpe" skrev i melding
...
You could download an all lower-case font.
See http://www.fontcenter.com/categories...nly/index.html

Taylor wrote:
Is there a way to format cells containing text in all caps so that they
are not in all caps?

David Biddulph wrote:
Fine as far as it goes, but remember that in such situations a
case-sensitive comparison with the lower case alternative would presumably
not succeed. You are presumably just seeing the upper case letters
*displayed* the same as lower case.
--
David Biddulph

True enough, but the OP only asked about displaying the information, not
making comparisons. My own approach would be to make sure that entries
are made using a mix of upper and lower case as needed, but that's not
what was asked.

Bill