/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 vote174 views1 answer
Add rows to datagridview vb.net
VBA
1 vote130 views1 answer
Vba listindex select multiple items vba
VBA
0 vote156 views1 answer
Excel text to columns line break
VBA
0 vote165 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote109 views1 answer
Excel autofilter vba
VBA
0 vote156 views1 answer
Change whcih control a user has selected vb
VBA
5 votes179 views1 answer
Excel vba right word from Long Integer
VBA
0 vote177 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote165 views1 answer
Vba parameter adodb null value
VBA
1 vote157 views1 answer
If inputbox cancel vba
VBA