/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 vote232 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote205 views1 answer
Vba argument is set
VBA
1 vote216 views1 answer
Textbox find and replace vb
VBA
0 vote223 views1 answer
Excel run macro every 5 minutes
VBA
1 vote235 views1 answer
How to remove zeros in excel
VBA
5 votes238 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote236 views1 answer
VB Error Code BC30201
VBA
0 vote238 views1 answer
Tester si une case est vide vba
VBA
0 vote233 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote215 views1 answer
Vba like with wildcard
VBA