Cleaning Data

Hi,
I'm looking to Clean some Data to ultimately be used for Pivot Table and Charts.

The data I pull can be downloaded in .xlsx or .csv formats. The issue is cells containing dates or numbers show a date or numbers but in the formula bar have something similar to:
="01/05/2015" or ="0450"
I want to remove the extra stuff leaving only the dates or numbers.

The attached files are identical just the different formats.

Also in the case of the number sets they will always have four digits. How do I format those cells to reflect the leading zeros like - 0450 vice 450 in the cell.

Thank you in advance,

Jim