Need help with date formatting

This is because your dates are actually text and need to be converted to real dates

Try this formula

=DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2))

and then format as desired

	B	C
2	28-05-2014	28/05/2014
3	02-04-2014	02/04/2014
4	21-05-2014	21/05/2014

To check if it is number or text use:

=ISTEXT(B2)

To convert without formula use Text to Columns feature in Excel. If you using Excel 2007-2013, it is located under the Data tab.
Highlight column with "dates", click on Text to Columns, select Delimited, then click Next, Next select Date and then Finish.

@lnaugle

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.