mbps to gb

MB to GB Excel Formula

Working on a spreadsheet and need to quickly convert an entire column of Megabytes into Gigabytes? Use our copy-paste formulas for both Excel and Google Sheets. Alternatively, calculate a single value with our homepage conversion utility.

Formula 1: Decimal Format (Storage)

Divides the value by 1000.

=A2/1000
Formatted to 2 decimal places:
=ROUND(A2/1000, 2)

Formula 2: Binary Format (RAM)

Divides the value by 1024.

=A2/1024
Formatted to 2 decimal places:
=ROUND(A2/1024, 2)

How to Use These Formulas

  1. Identify your data: Ensure the column you are converting contains only numbers.
  2. Select an empty cell: Click on an empty cell adjacent to your first MB value (e.g., cell B2).
  3. Paste the formula: Type or paste =A2/1000 into the formula bar. Replace A2 with the actual cell location of your first MB value.
  4. Drag to apply: Hit Enter to get your answer. Then, click the small square at the bottom-right corner of the result cell, and drag it down to automatically calculate the rest of your column.

Related Conversion Guides

MB to GB (RAM) Guide
1024 MB
1000 MB