/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 vote121 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote119 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote119 views1 answer
Vb.net change cursor to wait
VBA
18 votes171 views2 answers
Vba make word from bytes
VBA
0 vote123 views2 answers
Do until loop vba
VBA
0 vote120 views1 answer
Excel vba remove formatting from cell
VBA
1 vote114 views1 answer
Excel vba compare 2 rows
VBA
0 vote132 views1 answer
Vba open report
VBA
0 vote123 views1 answer
Select case vba
VBA
0 vote142 views1 answer
Vba cell all borders
VBA