/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 vote198 views1 answer
Vba first cell in range
VBA
0 vote201 views1 answer
Send webhook vbscript
VBA
0 vote226 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote267 views1 answer
Excel vba protect worksheet without password
VBA
6 votes219 views1 answer
Excel vba get the path of current workbook
VBA
0 vote202 views1 answer
Do until vb.net
VBA
0 vote213 views1 answer
Make all controls in an area not visable vb
VBA
0 vote241 views1 answer
How to enter Vbox manage commands
VBA
8 votes345 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote208 views1 answer
Vba add spaces
VBA