How to convert mb to gb in excel
Is it possible to format a number of bytes as KB/MB/GB/. using a Custom format string? I'm reporting in a Pivot Table and want to make it more readable. Note defining a custom field doesn't seem to be an option given we will be doing calculations on the numbers.
If we need the correct divisors of 1024, please try the formula:
Or try the VBA code:
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
- Marqué comme réponse George123345 Moderator lundi 22 décembre 2014 07:03
Toutes les réponses
Please try this number format:
And we also could use formula:
Hope it's helpful.
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
Thanks George, but these don't do KB/MB/GB with the correct divisors of 1024, 1024*1024, and 1024*1024*1024 for KB, MB and GB respectively.
Any other ideas to try?
If we need the correct divisors of 1024, please try the formula:
Or try the VBA code:
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
- Marqué comme réponse George123345 Moderator lundi 22 décembre 2014 07:03
Microsoft réalise une enquête en ligne pour comprendre votre opinion sur le site Web de Technet. Si vous choisissez de participer, l’enquête en ligne vous sera présentée lorsque vous quitterez le site Web de Technet.
How to convert mb to gb in excel
Is it possible to format a number of bytes as KB/MB/GB/. using a Custom format string? I'm reporting in a Pivot Table and want to make it more readable. Note defining a custom field doesn't seem to be an option given we will be doing calculations on the numbers.
If we need the correct divisors of 1024, please try the formula:
Or try the VBA code:
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
- Marked as answer by George123345 Moderator Monday, December 22, 2014 7:03 AM
All replies
Please try this number format:
And we also could use formula:
Hope it's helpful.
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
Thanks George, but these don't do KB/MB/GB with the correct divisors of 1024, 1024*1024, and 1024*1024*1024 for KB, MB and GB respectively.
Any other ideas to try?
If we need the correct divisors of 1024, please try the formula:
Or try the VBA code:
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
- Marked as answer by George123345 Moderator Monday, December 22, 2014 7:03 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.