So you need to make sure that the strings you use in the second and third arguments of the function are in the correct case.
Note that the CONVERT function is case-sensitive.
You can use the following table to obtain the identifiers for your required storage units: Unit Note that there are fixed identifiers for the different units. So if you want to convert the contents of cell A2 from Bytes to Kilobytes, you would use the CONVERT function as follows: =CONVERT(A2,”byte”,”kibyte”) to_unit is the unit to which you want to convert the number.from_unit is the unit in which number is expressed.number is the numeric value (or cell reference containing the value) that you want to convert.The syntax for the CONVERT function is: =CONVERT ( number, from_unit, to_unit) So, you can use it to convert Bytes to MB or GB and vice-versa. This function lets you convert numbers in one measurement system or unit to another. If you don’t want to go through the trouble of memorizing the conversion factors for storage size conversions, you can use the CONVERT function instead. Using the CONVERT Function to Convert Bytes to MB or GB Let us say you have the following numbers in bytes and want to convert all of them to MB: Similarly, to convert from GB to Bytes, multiply the number with 1024 * 1024 * 1024. This means, to convert from MB to Bytes, you need to multiply by 1024 * 1024. Similarly, to convert it to GB, you need to divide it by 1024 * 1024 * 1024.Ĭonversely, if you want to convert back, you need to multiply the storage size by 1024 each time. In other words, if you want to convert a storage size from bytes to MB, you need to divide it with 102 * 1024.
Kb mb gb calculator how to#
The basic method requires you to understand the relationship between the storage units and how to convert from one to the other. Using the Basic Conversion Formulae to Convert Bytes to MB/GB Using the CONVERT Function to Convert Bytes to MB or GB.Using the Basic Conversion Formulae to Convert Bytes to MB/GB.
0 kommentar(er)
