/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 vote154 views1 answer
Excel protect cells with formulas
VBA
0 vote173 views1 answer
Vbnet find highest value in chart
VBA
0 vote169 views1 answer
Returns an array from function vba
VBA
0 vote152 views1 answer
Vba argument is set
VBA
0 vote202 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote178 views2 answers
Do until loop vba
VBA
0 vote154 views1 answer
Le contrôle SpinButton (Toupie)
VBA
1 vote203 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
4 votes180 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote183 views1 answer
Excel vba textbox forecolor disabled
VBA