/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 vote216 views1 answer
Excel web scraping
VBA
18 votes267 views2 answers
Vba make word from bytes
VBA
0 vote200 views1 answer
Vba sheet visible
VBA
0 vote174 views1 answer
Excel vba concatenate range
VBA
0 vote188 views1 answer
Vb window.minimize
VBA
0 vote215 views1 answer
.net crash app
VBA
32 votes272 views2 answers
Excel vba column letter
VBA
0 vote250 views2 answers
Excel vba store array and write to sheet
VBA
5 votes205 views1 answer
Vba low word from Long Integer
VBA
0 vote190 views1 answer
Worksheet.pastespecial textbox
VBA