formula to complete the 10 digit bby adding 0

Copper Contributor


Hi experts, 


i want add 0's in front of my numbers



1    =0000000001

26  =0000000026



complete the 10 digit number





3 Replies

@rahul_oberoi Use a custom format with ten zeroes, like 0000000000

Yes, how to do that I am really not sure as of now.

@rahul_oberoi On a Mac right now but it's similar to Windows. Select the cells(s), press Ctrl-1 and create a custom format as below.

Screenshot 2021-11-29 at 20.26.19.png


Perhaps the link below helps to get started with custom formatting in general.