/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 vote152 views1 answer
Vba loop through files in folder
VBA
0 vote157 views1 answer
Excel vba paste all to each sheet in workbook
VBA
1 vote133 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote134 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote143 views4 answers
How to continue formula in below line in vba code
VBA
0 vote187 views2 answers
Excel vba store array and write to sheet
VBA
0 vote175 views1 answer
Set datetimepicker value to null vb
VBA
0 vote125 views1 answer
Style percent not found vba
VBA
0 vote136 views1 answer
VB Error Code BC30201
VBA
0 vote136 views1 answer
Returns an array from function vba
VBA