Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers

See how to Convert 35 & 100 to 00-035 & 00-100 using Power Query, a Custom Column and the Text.PadStart Power Query Function. This trick comes thanks to Eric Giroux @ YouTube.
Download File:
Related Video:
Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column

[iwantovani]

Thanks Mike, it's very helpfull.

[marcelbeug]

At around 3:00 you suggest to search internet for information on Text.PadStart.

[richardmei]

Is there a way to convert a date column to a custom format? Say I want "9/20/2017" to show as

[bholaabdullah]

hello
i have a query
if we add data to one sheet it should automatically update as a value in master data and goes on adding when we input new data

example i input data as 12345 it should add in master data as value, then if i add 23456 it should add in master data bellow 12345 ( for permanent )
awaiting you kind reply

[BillSzysz]

Thanks Mike :-))
A little bit of M makes life simpler ;-))

[EricGiroux]

thanks Mike, you're a wonderful teacher!

[mannysingh]

Mike please do videos on Machine Learning & Data Science in Excel if possible, It would be highly appreciated!

[linelson]

So cool!
I was need it in last friday!