In this article, we are going to use Microsoft Excel functionality to automatically convert value in KB to MB, GB and TB.
As an example, below table name DHIYA size is at 8888888888KB. You wanted to convert the value into MB, GB and TB automatically.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Table Name | Size in KB | Size in MB | Size in GB | Size in TB |
| 2 | DHIYA | 8888888888 | 8680555.555 | 8477.105034 | 8.278422885 |
=CONVERT(B2,”kibyte”,”Mibyte”)
=CONVERT(C2,”Mibyte”,”Gibyte”)
=CONVERT(D2,”Gibyte”,”Tibyte”)
Reference
The syntax will be as =Convert(value,”from”,”to”)
• value = cell from the excel. This should contain only numbers.
• from = the source number.
• to = the target number.
• from / to = the prefixes will be kibyte (lowercase), Mibyte, Gibyte and Tibyte
