From Wikipedia, the free encyclopedia. Know your customer (KYC) is the process of a business, identifying and verifying the identity of its clients. The term is also used to refer to the bank regulation which governs these activities. Know your customer processes are also employed by companies of all sizes for the purpose of ensuring their proposed agents, consultants, or distributors are anti-bribery compliant.
Add one zero in front of a number through âFormat Cellsâ. To add the zero (0) in front of every number using the âFormat Cellsâ option follow the below mentioned steps: 1  Select the range of mobile numbers. 2  And press the key âCTRL+1â on the keyboard.3  The âFormat Cellsâ dialog box will appear.. 4  In the âNumberâ tab select âCustomâ from the list. =TEXT(A2,â00000000000â³). 2  Press Enter on the keyboard. 3  The function will return the mobile number with the added zero in front of the number. 4  Now copy the formula by pressing the key âCTRL+Câ on the keyboard and paste in the range B3:B10 by pressing the key âCTRL+Vâ.
Go to Format Cells-Custom. Type the required format into the list first. To prefix 0 before the text characters in an Excel column, use the Format 0####. Remember, use the character # equal to the maximum number of digits in a cell of that column.