/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 vote342 views1 answer
Excel vba select multiple shapes
VBA
0 vote379 views1 answer
If statement vdhl
VBA
0 vote330 views1 answer
Excel run macro every 5 minutes
VBA
0 vote352 views1 answer
Excel vba combine ranges
VBA
0 vote320 views1 answer
Excel vba center userform
VBA
0 vote356 views1 answer
Vbnet convert charatcer to binary
VBA
7 votes353 views1 answer
Vba array declaration
VBA
0 vote331 views1 answer
Excel vba formatconditions positive
VBA
0 vote367 views1 answer
Excel vba convert cells address
VBA
0 vote328 views1 answer
Vba declare 64-bit ptrsafe
VBA