/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 vote284 views1 answer
Change the first item in a queue vb.net
VBA
5 votes347 views1 answer
Vba low byte from INTEGER
VBA
5 votes327 views1 answer
Excel vba left word from Long Integer
VBA
0 vote310 views1 answer
Vba remove the first character of string
VBA
1 vote283 views1 answer
Add control vb
VBA
0 vote295 views1 answer
Vb ternary
VBA
0 vote302 views1 answer
Excel vba urlmon
VBA
0 vote312 views1 answer
Sort dictionary by key vba
VBA
1 vote280 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote268 views1 answer
Vb.net visible property dgv collumn not working
VBA