/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 vote124 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote125 views1 answer
Vbscript check if string is empty
VBA
5 votes159 views1 answer
Excel vba first byte from INTEGER
VBA
1 vote151 views1 answer
Perform http request in vb.net
VBA
0 vote121 views1 answer
Ribbon show/hide
VBA
-1 vote135 views2 answers
Excel vba delete empty rows
VBA
1 vote129 views1 answer
Excel vba unload userform
VBA
0 vote129 views1 answer
Vb.net visible property dgv collumn not working
VBA
7 votes147 views1 answer
Excerl vba array to range
VBA
1 vote130 views1 answer
Find and replace textbox
VBA