/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

2 votes161 views1 answer
Vba file from path
VBA
0 vote194 views1 answer
Vba userform textbox wrap text
VBA
1 vote147 views1 answer
Excel vba saveas force overwrite
VBA
0 vote150 views1 answer
Vlookup columns not next to each other
VBA
0 vote204 views2 answers
Excel vba store array and write to sheet
VBA
0 vote159 views1 answer
Remove first character from string vb
VBA
0 vote161 views1 answer
Excel vba automatic calculation
VBA
18 votes299 views3 answers
Excel-vba make integer
VBA
2 votes148 views2 answers
Excel vba copy values range to another range
VBA
0 vote156 views1 answer
Vba parameter adodb null value
VBA