Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column

Download File:
See how to add the prefix “00-“ to a column of Account Numbers using Transform, Text Column, Format, Add Prefix feature in Power Query (Get and Transform).
Convert Number Account Numbers to Text Account Numbers with a Prefix.

[zaydarendse]

Thanks I knew i'd find the solution with you :))

[rashidthattari]

Hi mike,
Thanks for ur vdo, how can we get the serial number in a single excel table from a table which has begin number and end number. Eg 1-1000, 5000-10000, 15000-25000, etc..

[CurbalEN]

We made the same video on the same day....what are the odds for that? Emin is following both of us and let me know about it!!
Funny....
/Ruth

[ljubicar]

Short but useful video. Thanks! May I use this opportunity to ask for more videos for accountants, since the majority of videos are related to trade companies. I work in the bank, and we don't have many tutorials devoted to our field of business.

[brosseauchristian]

Hi Mike, thanks four your video. How can we transform/format so it always becomes a "00-000" format even if it originally contains a 2-digit or 3-digit number? Thanks again!

[EricGiroux]

Hi Mike,

Pretty nice, I wasn't aware of that tool!

For someone who would like same length account number could add a column and use "00-"&Text.PadStart([column], 3, "0")).

Thanks again!

[djeritorres]

Hola... Es una actualización nueva?... Saludos

[automationguide]

That's very quick & short trick.

Thank You !!