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.

--

You got an answer to these yesterday - instead of simply reposting
identical information, let us know what didn't work about the solutions
suggested.

In article ,
"Port Man" wrote:

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.

No, something happened and I thought it didn't send yesterday. Sorry.

--