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â.
Tips & Warnings. 1  Remember that numbers reference rows and letters reference columns. 2  For example, A1 refers to column A, row 1. 3  You may add data for cells that are not next to each other. 4  An example of this type of formula is: =SUM(A1,A5,A9,B56). 5  Do not use spaces in your formula.ighlight the data that you want to add. It can be a column or a row. Make sure there is only numeric content in the cells. Click and drag your mouse until all the cells are highlighted. Click the Auto-Sum icon on the task bar. It looks like an E.. The sum will appear at the end of the row or column.