How to fill cells with 0s?

[manap_98]

Hello. Here I have a column that must contain numbers with 12 digits. However, sometimes I have 11 digits where 0 must be added in the front, so 0 + 11 digits. I changed the data type to text, even in that case 0 are removed from the data. How can I add 0 with measures or is it possible to do that if the length is less than 12, so 0 must be added to the beginning. 

[PhilipTreacy · Accepted solution]

Hi @manap_98 

Click into Model View then click on the column you want to format.

Under Formatting choose Format->Custom then enter 12 zeros as the format

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[amitchandak]

@manap_98 , Create new column

if(len([bin]) =11, "0" & [bin] , [bin])