Forum Discussion

Copper Contributor

Jul 06, 2020

Solved

Convert column of MB to GB

How do I convert a column of MB values to rounded GB values? https://s.natalian.org/2020-07-06/mb-to-gb.mp4

ExcelExciting
Jul 06, 2020
Hi kaihendry

You can apply the below formula to do the conversion that will work perfectly

=CONVERT(65536,"Mibyte","Gibyte")

To know more about the convert function pls see the below link

https://youtu.be/k2G7n-xQNpw

https://support.microsoft.com/en-us/office/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60516&ui=en-us&rs=en-us&ad=us

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Copper Contributor

Jul 06, 2020

65,536

Displays as 66 instead of 64. Problem. Argh.

I guess I can just apply a formula along the column?

MVP

Jul 06, 2020

You can apply the below formula to do the conversion that will work perfectly

=CONVERT(65536,"Mibyte","Gibyte")

To know more about the convert function pls see the below link

https://youtu.be/k2G7n-xQNpw

https://support.microsoft.com/en-us/office/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60516&ui=en-us&rs=en-us&ad=us

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

OranjeNY
Copper Contributor
Jan 17, 2024
This list is life-changing! thank you

Resources