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