=LOWER(A1)
If you want to put it back in the original cell, Copy, and then Edit/ Paste
Special/ Values
--
David Biddulph


"JB" wrote in message
...
Hi, I need to convert cells that was typed in caps lock only, to lower
case.
How do I do this without having to retype the whole cell??