I've just loaded data into Dynamics 365 CE (Online) using the Accounts Template.

From my source Excel file I've converted the Main number to Text and added a leading zero.

When I added the data to the template and import into the application the leading zero is not displaying and the format is not the same as other records.

How can I make all phone number look the same

The numbers within the borders is the format required