Convert column of MB to GB

Occasional Contributor

How do I convert a column of MB values to rounded GB values?

3 Replies

@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...









Displays as 66 instead of 64. Problem. Argh.


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

Best Response confirmed by kaihendry (Occasional Contributor)

Hi @kaihendry 


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









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

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