How do I Use Megabytes & Kilobytes in an Excel Spreadsheet? (4 Steps)

By C. Taylor

Excel 2013 recognizes binary or metric prefixes for bits and bytes.
i flik47/iStock/Getty Images

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.

Step 1

Enter the Convert function in a blank cell, using the following format:

=Convert(value,"from","to")

Step 2

Change "value" in the formula to the number you want converted. You can also enter a cell reference, such as "A1," to convert a number from an existing cell. However, the referenced cell must contain only a number without any text, including the unit abbreviation.

Step 3

Change "from" to the value's original unit. Use "bit" or "byte" for any units of bits or bytes, and add the "ki," "Mi," "Gi" and "Ti" prefix to designate kilo, mega, giga and tera prefixes. Units are case-sensitive and must be surrounded by quotation marks.

Step 4

Change "to" to the unit you're converting to. Use the same format that you used in the "from" field. As an example, to convert 2,048 kilobytes to megabytes, use the following formula:

=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")

×