/VBA/Excel how to format bytes as KB, MB, GB

Excel how to format bytes as KB, MB, GB

'Use Excel Number Formats to format bytes as KB or MB or GB.

'Select the range and apply the following number format:
[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

'Or for Excel versions that use the comma as the decimal separator:
[<1000000]#.##0,00" KB";[<1000000000]#.##0,00.." MB";#.##0,00..." GB"

Source: academy.excelhero.com

Similar codes

0 vote260 views1 answer
How to extract a file from an ISO:
VBA
0 vote263 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote266 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote282 views1 answer
Excel vba unlock sheet without password
VBA
1 vote262 views1 answer
Excel vba first and last row and column in range
VBA
7 votes296 views1 answer
Vba array declaration
VBA
0 vote278 views1 answer
Vba get relative cell address
VBA
0 vote301 views1 answer
Move bindingnavigator vb
VBA
0 vote279 views1 answer
VBA is form loaded
VBA
0 vote267 views1 answer
Vba border weight
VBA