/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

31 votes532 views1 answer
Excel vba function to convert column number to letter
VBA
8 votes315 views1 answer
Vba make integer
VBA
0 vote236 views1 answer
Enter into cells data grid view
VBA
0 vote229 views1 answer
Test if form is open vb
VBA
0 vote242 views1 answer
Make your computer talk vbscript
VBA
0 vote235 views1 answer
Vbnet check if number is even or odd
VBA
0 vote227 views1 answer
Get current year vb
VBA
0 vote254 views1 answer
Vba random number
VBA
3 votes248 views1 answer
Vba not equal
VBA
0 vote173 views1 answer
Vba select file in folder
VBA