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

Conditional Formatting based on Another Cell in Google Sheets/Excel

In Microsoft Excel Spreadsheet or google sheets, when you want to format a specified cell or cell range based on the value of a different cell, for example, formatting the first row based on the value of a cell in ...

Compare Two Strings in Excel/Google Sheets

This article will talk about how to compare two given strings in a Microsoft Excel spreadsheet or Google Sheets. How to compare two strings in Excel by using VBA macros to see if they are the same, if they are ...

Compare effect of (non-annual) compounding periods on growth

This article will talk about how to calculate the trend or effect of future value changes for different compounding periods in a Microsoft Excel spreadsheet or Google Sheets via a formula. What is the period of compound interest? The compounding ...

Coefficient Of Variation in Excel/Google Sheet

This article will talk about how to calculate the coefficient of variation by formula in a Microsoft Excel spreadsheet or Google Sheets.  What is the Coefficient of Variation? The coefficient of variation is the ratio of the standard deviation of ...

VLOOKUP Function & Formula in Excel

In our daily work, we often encounter the situation of finding data based on the original data and conditions provided, such as finding cell phone numbers based on name, finding employee names and positions based on HRID, etc. When we ...

Sidebar