Excel formula question - Convert to specific date format?

I have data in the format YYYYMMDD which I need converted to MM-DD-YYYY. I need a formula solution in Excel.

For example,
20070214 -----> 02-14-2007

Assume data is in Column A and the new data will appear in Column B.

First person with a WORKING formula get 10 points.
10 answers 10