/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 vote196 views1 answer
Vba first cell in range
VBA
0 vote188 views1 answer
Vba add shape oval
VBA
0 vote178 views1 answer
Loop through lines in text file vb net
VBA
0 vote202 views1 answer
Excel delete ever other vba
VBA
0 vote188 views1 answer
How to use if condition in time vba
VBA
2 votes176 views1 answer
Vba array contains
VBA
0 vote191 views1 answer
Vba is integer
VBA
4 votes169 views1 answer
Excel vba how to reset usedrange
VBA
0 vote190 views1 answer
Regex numeric digits
VBA
0 vote191 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA