Excel’s Convert function has been around for a long time, but it wasn’t until Excel 2013 that Microsoft added bits and bytes to the Convert function’s capabilities. With the proper formatting, the Convert function quickly converts bits and bytes with any applicable prefix, so you can use kilobytes and megabytes in Excel. =Convert(value,“from”,“to”) =Convert(2048,“kibyte”,“Mibyte”) Note that “kibyte” uses all lowercase characters, as opposed to “Mibyte.” As another example, to convert the number in cell A1 from bits to gigabytes, use the following formula: =Convert(A1,“bit”,“Gibyte”) Tips Writer Bio
