/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 vote314 views1 answer
Vba len variant
VBA
8 votes385 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote333 views1 answer
Excel vba disable screen update
VBA
0 vote284 views1 answer
Add items to combobox vb.net
VBA
0 vote392 views1 answer
Excel vba delete columns in range
VBA
0 vote336 views1 answer
Columns dont autoresize on program start vb.net
VBA
3 votes358 views1 answer
Extract word in a text in excel
VBA
0 vote301 views1 answer
Vba file size
VBA
1 vote286 views1 answer
Vba listindex select multiple items vba
VBA
0 vote317 views1 answer
Do while not vb.net
VBA