/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 vote180 views1 answer
Vba add spaces
VBA
0 vote213 views1 answer
Set datetimepicker value to null vb
VBA
0 vote190 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote177 views1 answer
Vba loop through table
VBA
0 vote168 views1 answer
Vba code to open a file with login rights
VBA
0 vote180 views1 answer
Rotate image by any angle vb.net
VBA
3 votes184 views1 answer
Extract the nth word from a text string
VBA
0 vote254 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote179 views1 answer
Excel vba assign shortcut key to button
VBA
31 votes325 views1 answer
Excel-vba how to convert a column number into an excel column
VBA