/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

1 vote240 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote240 views1 answer
Get current url vb.net
VBA
0 vote234 views1 answer
Vba format currency
VBA
0 vote242 views1 answer
Vbnet find highest value in chart
VBA
1 vote235 views1 answer
Textbox find and replace vb
VBA
0 vote243 views1 answer
Default host vbox address
VBA
0 vote250 views1 answer
Excel vba round to whole number
VBA
0 vote249 views1 answer
Vba remove numbers from string
VBA
0 vote278 views1 answer
Excel vba first column in range
VBA
0 vote263 views1 answer
Pivot data source not accepting table named range vba
VBA