/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 vote213 views1 answer
Vb get ip address
VBA
3 votes192 views1 answer
Excel vba last row in range
VBA
5 votes232 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote202 views1 answer
Putting marquee in vb.net
VBA
2 votes166 views1 answer
Excel vba pause
VBA
1 vote204 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote213 views1 answer
Vba copy file
VBA
1 vote202 views2 answers
Vba remove first 2 characters from string
VBA
0 vote215 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote199 views1 answer
Excel vba extract year
VBA