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â.
Place your cursor in an empty cell below or beside the column you want to calculate. Select the âFormulaâ tab from the Ribbon and click on âAutoSumâ under the âFunction Libraryâ group. To add all the numbers in a column, click on the âAutoSumâ button. Excel 2007 will select the calculated cells on the worksheet for you.Press the âEnterâ key to accept the calculation or manually select the cells you want to calculate, then press the âEnterâ key.Repeat the calculation for additional columns or rows, or copy the formula to your other cells. To copy your calculation to another cell, select the cell with the formula.rag the cell in the direction of the cells where you want the formula added. The formula will be repeated on those cells. Calculate the average of numbers by placing your cursor in an empty cell and clicking on the arrow for the âAutoSumâ button in the âFormulaâ tab.