title: Excel Date Conversion from yyyymmdd to mm/dd/yyyy
body: <p>I have been searching for about an hour on how to do this in Excel.</p>
  
  <p>I have an Excel file that was created from an old system and I am pulling information from a SQL Server Database, I will be inputting the information back into the SQL Server Database and would like the Dates to match.  </p>
  
  <p>I have tried Creating a Custom Format, but I am unsure if I even did it Correctly.  I found several places where they want to go the other way <code>mm/dd/yyyy</code> to <code>yyyymmdd</code>  but they have not been helpful.</p>
  
  <p>I am unfamiliar with using VBA in any Microsoft Products otherwise I am sure that this would be a simple Task.</p>
  
  <p>I have two separate columns that need to be changed.</p>
  
  <p>How do I Format the entire column from  <strong><code>(float)</code>yyyymmdd</strong> to a <strong><code>(Date)</code>mm/dd/yyyy</strong> </p>