formula to complete the 10 digit bby adding 0

Copper Contributor

 

Hi experts, 

 

i want add 0's in front of my numbers

 

example 

1    =0000000001

26  =0000000026

136=0000000136

 

complete the 10 digit number

 

 

rahul_oberoi_0-1638205069565.png

 

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.

https://exceljet.net/custom-number-formats