Forum Discussion

kaihendry

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

excel

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

TheAntony

Iron Contributor

Jul 06, 2020

kaihendry Simple but not a perfect solution - you can set the number format to display in thousands (basically divided by 1000 instead of 1024) by adding a comma to the custom number format. (you can add as many as you want - each comma will display divided by another 1000). Remember that the number itself will not change, just the format...