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â.
Add the values in a column or row by using a button. You can use AutoSum to quickly sum a range of numbers in a column or row. Click an empty cell below a column of numbers or to the right of a row of numbers, and then click AutoSum. Excel selects what it determines to be the most likely range of data.he first argument (109) specifies that you want to add the values in the range and ignore hidden values. To include the hidden values, you instead use 9 as the first argument. For in-depth information, see the articles SUBTOTAL function and Total the data in an Excel table.