This post will guide you how to** convert value in KB format to MB, GB, PB and TB** automatically in Microsoft Excel. How do I convert size in bytes to KB, MB, GB, TB and PB in Excel 2013/2016.

For example, assume that you have a list of data which unit is bytes, and you wish to convert the unit of these values to KB, MB, GB, TB. You should know that the unit conversion rate is 1024 between each adjacent unit. So you can create a formula similar as the below:

**=B1/1024**

If you want to convert the unit from KB to MB, and you can type the following formula into a blank cell, then press Enter key.

=B2/1024

If you want to convert the unit from byte to MB, and you can use the following formula:

**=B1/1024/1024**

Or you can also use another formula based on the** CONVERT function** to convert a number from one measurement system to another.

The syntax of the Convert function is as below:

**=CONVERT (number, from_unit, to_unit)**

**Where,**

**Number** – cell values that you want to convert its unit.

**From_unit** – the source unit

**To_unit** – the target unit

The prefixes of from/to unit should be Kibyte, Mibyte, Gibyte and Tibyte.

**Convert KB to MB **

To convert size in KB to MB, and you can use the following formula:

** ****=CONVERT(B1,”kibyte”,”Mibyte”)**

** **

**Convert MB to GB**

If you wish to convert the unit from MB to GB, and you can use the following convert formula:

** ****=CONVERT(B2,”Mibyte”,”Gibyte”)**

** **

**Convert GB to TB**

If the unit of your original data is MB, and you wish to convert it as GB, just use the below Convert formula:

** ****=CONVERT(D2,”Gibyte”,”Tibyte”)**

Related Posts

CAGR Formula Examples in Excel
CAGR in Excel is a formula that calculates the compound annual growth rate for any invested amount over the specified years or timeframe. Although there is no direct function in Excel that can help us identify the CAGR value, there ...

Build Hyperlink With VLOOKUP in Excel
You might have come across a task in which you were assigned to build hyperlinks, which seems very easy, and if you are new to excel or don't have enough experience with it, then you might wonder about doing this ...

Break ties with helper COUNTIF and column
Suppose you got a task to adjust the values that contain the ties; what would be your first attempt to break the ties of the given value? If you are wondering about doing this task manually, let me add that ...

Calculate Total Cost with Excel VLOOKUP Function
In today's article we will show you how to calculate the total cost for a given weight using the Excel VLOOKUP function. This function will help us to find the appropriate unit price for that weight and then we can ...

Excel Formulas To Calculate The Bond Valuation
Assume that you've been assigned a task of calculating bond valuation; so if you are new to Ms Excel or do not have much experience with it, then I am pretty sure about it that doing this task manually might ...

BMI Calculation Formula In Ms Excel
You might have come across a task in which you were assigned to make BMI calculations of the supplied numbers, and you may be looking for an efficient approach to accomplish this process rather than doing BMI calculations manually, by ...

Working Time Calculation Based on Timesheets
In the office, a special machine record the time when you start working (clock in office) and when you finish working (clock out of office). We can calculate the total working time by subtracting the end working time from the ...

Basic Price Discount Calculation with Excel VLOOKUP Function
We often encounter product discounts in our shopping. Depending on the level of spending, the mall will offer different percentages of discounts. Usually, the more you spend, the bigger the discount, while the less you spend, the smaller the discount. ...