/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 vote132 views1 answer
Text to speech vb.net
VBA
0 vote141 views1 answer
Vba first line of string
VBA
0 vote135 views1 answer
Open application from vbnet
VBA
1 vote153 views1 answer
Excel vba autofit
VBA
3 votes155 views2 answers
Vba active workbook path
VBA
-1 vote145 views1 answer
Vba code to add new column in table
VBA
2 votes141 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote134 views1 answer
Excel vba disable screen update
VBA
0 vote156 views1 answer
Excel filter by date not working vba
VBA
3 votes142 views1 answer
Excel vba last row in range
VBA