MB to GB Excel Formula
The exact formulas to type, which divisor matches which label, and why CONVERT does not work for storage units.
Conversions completed
The formula you actually need
Excel has no built-in function for digital storage units, so MB to GB is a plain division. Which divisor you use decides whether your answer matches the label on the drive or the number Windows shows you.
| What you want | Formula for a value in A1 | Result for 25,000 |
|---|---|---|
| Decimal GB (matches packaging) | =A1/1000 | 25 GB |
| Binary GiB (matches Windows) | =A1/1024 | 24.41 GiB |
| GB rounded to 2 dp | =ROUND(A1/1000,2) | 25.00 |
| Label with the unit | =A1/1000&" GB" | 25 GB |
Formatting instead of concatenating
Appending the unit as text turns the result into a string, which breaks any later SUM or chart. Use a custom number format instead: select the cell, press Ctrl+1, choose Custom, and enter 0.00" GB". The cell stays numeric and still displays the unit.
A whole column at once
- Enter =A1/1000 in B1.
- Point at the bottom-right corner of B1 until the cursor becomes a plus.
- Double-click to fill the formula down to the last row of data.
- To keep the divisor configurable, put 1000 in cell E1 and use =A1/$E$1 so the whole column follows one cell.
Converting the whole ladder in one table
Storage conversions are just powers of 1000 (decimal) or 1024 (binary). Keep one divisor cell per system and reference it with an absolute address, rather than retyping 1024 in forty formulas.
| From | To | Decimal formula | Binary formula |
|---|---|---|---|
| KB | MB | =A1/1000 | =A1/1024 |
| MB | GB | =A1/1000 | =A1/1024 |
| GB | TB | =A1/1000 | =A1/1024 |
| MB | TB | =A1/1000000 | =A1/1048576 |
Common mistakes
- Using the CONVERT function. It handles length, mass, temperature and volume but does not accept byte units, so =CONVERT(A1,"MB","GB") returns an error.
- Mixing the two systems in one sheet. If some rows divide by 1000 and others by 1024, totals are meaningless.
- Dividing by 1024 and labelling the result GB. It is GiB. The number is right, the unit name is not.
- Applying a custom format that rounds to zero decimals on values below 1 GB; use 0.00 to keep small values visible.
Related pages
Frequently Asked Questions
What is the formula for MB to GB in Excel?
=A1/1000 for decimal GB, or =A1/1024 for binary GiB. Excel has no storage unit function.
Why does CONVERT fail for MB and GB?
CONVERT supports length, mass, time, temperature, volume and area, but not digital storage units.
How do I show the unit without breaking the number?
Use a custom number format such as 0.00" GB" instead of concatenating text.
