I have a query that imports a sheet from another workbook, and one of the fields it imports is the "Rev" which is stored as 01, 02, 03, etc. as Text. However, the query always pulls these in as 1, 2, 3, etc.

How can I force it to be '0n'? Do I have to reformat the value every time its referenced?

CodePudding user response：

You can use CONCAT() with just one parameter to do this. For example =CONCAT(Sheet2!A1)

CodePudding user response：

From here we get it into Power Query

Loading from Power Query back to Excel