Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

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

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

Copper Contributor

Jan 17, 2024

This list is life-changing! thank you

Share

Resources