I'm looking for the following formulas:

1. I have cells that have dates in yyyymmdd format and I want to
convert them to mmddyyyy format.

2. I want to make another column with the mmddyyyy format and convert
it to unix date/time.

3. Convert a cell with all UPPERCASE to all lowercase.

Thanks.

--