Make Upper Case in cells become lower case

Make Upper Case in cells become lower case - does anyone know how to do this? I mean as a permanent change not a formula linking sheets. Thanks

You could maybe use a macro along the lines of:

Sub MACRO_1()
Dim cl
For Each cl In ActiveSheet.Cells.SpecialCells(xlCellTypeConstants)
    cl.Value = LCase(cl.Value)
Next
End Sub

Press alt+F11 to enter the vba editor, insert a new module (insert->module) and then copy that code in and then run (run menu or F5).

It will work on the activesheet and only work on constants (not formulas)

beautiful thanks