How to Auto Convert KB, MB, GB, PG, TB in Excel

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

convert kb mb unit1

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

=B1/1024/1024

convert kb mb unit2

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 kb mb unit3

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 kb mb unit4

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”)

convert kb mb unit5

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 ...

Calculate Cumulative Totals with Excel SUM Function

Today, through a simple example, we will show you how to use one of the most common-used Mathematical functions in excel, the SUM function, to add up the sum. In our daily life, we keep an account of what we ...

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 ...

Calculate The Period of Loan or Investment in Excel

In our daily life, most of us will invest or take a loan, so we need to master some simple financial functions to calculate the period needed for loans or investments. If you work as an accountant, you need to ...

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. ...

Sidebar