Power Query drops leading zeros when loading digits from column formatted as text

Welcome to the forum.

You will need to make sure that PQ reads the values as text, not numbers.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

The cells that drop leading zeros are highlighted in the attached file.

When you import the table into PQ, you will see a step added automatically (changed type) - simply remove this step.

To stop it happening, go here and scroll down to "How to stop the automatic Changed Type step?": https://exceloffthegrid.com/changed-...p-power-query/

I suspect that you have PQ settings to automatically select data types. Change this to Never detect in the File-->Options and Settings-->Query Options-->Data Load

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.