/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

4 votes144 views2 answers
Vba create folder if not exist
VBA
0 vote134 views1 answer
Excel vba disable screen update
VBA
0 vote173 views1 answer
Amd64 vs arm64 linux
VBA
0 vote147 views1 answer
Vba word open document read only
VBA
0 vote143 views1 answer
Excel vba calculate
VBA
2 votes141 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote158 views1 answer
Vba table header name
VBA
0 vote138 views1 answer
Add items to combobox vb.net
VBA
4 votes154 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
1 vote137 views2 answers
Vba function return array
VBA