Nov 29 2021 09:01 AM
Hi experts,
i want add 0's in front of my numbers
example
1 =0000000001
26 =0000000026
136=0000000136
complete the 10 digit number
Nov 29 2021 09:09 AM
@rahul_oberoi Use a custom format with ten zeroes, like 0000000000
Nov 29 2021 09:11 AM
Nov 29 2021 11:44 AM
@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.
Perhaps the link below helps to get started with custom formatting in general.