How Change Percentage format to Normal Number format in Excel

1. Select the Cells which contains the Percentage values Like
10%
20%
30%
2. Change the Number format to General and data will appear like
0.1
0.2
0.3
3. Enter the Number 100 in any cell and Copy this Number.
4. Select the Cells with Decimal values.
5. Select Paste Special and Multiplication option in Paste Special Dialog box.
6. Decimal number will change to Whole Numbers like
10
20
30

Keep Learning
Win Corporate
Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Advertisements

Vookup function in Excel

Vlookup is one of the Extensively used Excel function. It looks for the value in the Leftmost column in the Table array in Excel.

Syntax:

VLookup(, , , [RangeLookup])

Parameters:

  1. Ā lookupvalue – Value need to be searched in the Table Array
  2. TableArray – Contains the group of value
  3. ColumnIndexNo – Table array Column No where our reference value is found.
  4. [RangeLookup] – Takes two values true [approximate matching] and false [exact matching]

Example:

vlookupex

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432