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â.
=SUM(BELOW) adds the numbers in the column below the cell youâre in. =SUM(RIGHT) adds the numbers in the row to the right of the cell youâre in. If you make changes to the numbers youâre adding, select the sum and press F9 to show the new results.You can also use more than one formula in a table.lick the Table Tools Layout tab and click Formula. In the Formula box, delete the SUM formula, but keep the equal sign (=). Then click the Paste function box and click the function you want. Between the parentheses, choose which table cells you want to include in the formula: