/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 vote178 views1 answer
Add items to combobox vb.net
VBA
0 vote197 views1 answer
Vba keep command window open
VBA
0 vote186 views1 answer
Excel vba cell on change
VBA
0 vote179 views1 answer
Excel vba disable copy paste
VBA
0 vote198 views1 answer
Vba listbox remove all items
VBA
0 vote177 views1 answer
Vb net dgv doesn't keep currency format
VBA
-1 vote220 views1 answer
How save excel through visual basic
VBA
0 vote183 views1 answer
VB get external IP address
VBA
0 vote196 views1 answer
Excel R1C1 mode
VBA
0 vote196 views1 answer
Vba sort multiple columns
VBA