Forum Discussion
kaihendry
Jul 06, 2020Copper Contributor
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
- 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
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
Jul 06, 2020Iron Contributor
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...
kaihendry
Jul 06, 2020Copper Contributor
65,536 |
Displays as 66 instead of 64. Problem. Argh.
I guess I can just apply a formula along the column?
- 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
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
- OranjeNYJan 17, 2024Copper ContributorThis list is life-changing! thank you