/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 vote219 views1 answer
Excel vba send HTTP POST to server
VBA
-1 vote216 views2 answers
How close excel through visual basic
VBA
0 vote239 views1 answer
Vba random number
VBA
0 vote257 views1 answer
VBA Sort RossetaCode
VBA
0 vote321 views2 answers
VB
VBA
0 vote232 views1 answer
VB Error Code BC30201
VBA
3 votes237 views1 answer
Excel insert blank row for value change in column
VBA
0 vote210 views1 answer
Vba find last column in a row with data
VBA
0 vote229 views2 answers
Open url from vba
VBA
0 vote222 views1 answer
Excel vba cell on change
VBA