/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

7 votes397 views1 answer
Excerl vba array to range
VBA
1 vote354 views1 answer
VBA Loop through recordset
VBA
2 votes332 views1 answer
Date format for ms chart vb.net
VBA
0 vote366 views2 answers
Checking and changing system volume vb.net
VBA
4 votes357 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote369 views4 answers
Jwt token vb.net validation
VBA
0 vote334 views1 answer
Excel autofilter vba
VBA
27 votes499 views2 answers
Vba check if file exists
VBA
0 vote308 views1 answer
How to sort datagridview in vb.net
VBA
0 vote343 views1 answer
Vba verticalalignment
VBA