Issue Importing All Data from an Excel Column

Hi there,   First time poster - I'm working with importing several Excel files into Power BI.  Each of them contains a CUSTOMER ID column.  Within Excel, the column is formatted as TEXT.  Within th...