/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 vote146 views1 answer
Excel vba linter
VBA
0 vote155 views1 answer
Vbnet click on dgv cells
VBA
3 votes150 views1 answer
Vba continue for each loop
VBA
1 vote137 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote144 views1 answer
Switch pictures with buttons vb.net
VBA
2 votes138 views1 answer
Vba split string
VBA
0 vote142 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote142 views1 answer
Internet explorer reference vba
VBA
0 vote144 views1 answer
Convert unix to date vba
VBA
0 vote139 views1 answer
Vba like with wildcard
VBA