Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
258
Views
Topic starter
Hi Everyone
In my data set, I have an ArticleCode in Data Type: Text.
In order to reference with other tables, I need to pad with leading 0 to an 18-digit number.
I've tried the following formula, but still end up with an error:
=Text.PadStart( [Article Code], 18, 0)
How do I correct this error?
Thank you!
Eduard
Posted : 30/06/2017 5:39 am
Hi Eduard,
Text.PadStart is looking for a text value for the pad. Try putting your zero in double quotes like this:
=Text.PadStart( [Article Code], 18, "0")
Mynda
Posted : 30/06/2017 6:56 am
Topic starter
HI Mynda
As simple as that! 
Thank you very much!
Eduard
Posted : 30/06/2017 11:26 am
