# 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.

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.

Follow

10 answers
10

Are you sure you want to delete this answer?