/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 vote294 views1 answer
Vba delete array element
VBA
0 vote353 views1 answer
Vba foreach 2d array
VBA
0 vote292 views1 answer
Vba first line of string
VBA
0 vote268 views1 answer
Excel vba linter
VBA
1 vote322 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote307 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote297 views1 answer
Vba loop through table
VBA
1 vote313 views1 answer
Vba date to unix timestamp
VBA
1 vote308 views1 answer
Excel format cell as kilowatts
VBA
0 vote293 views1 answer
Vba format currency
VBA