/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 vote337 views1 answer
Vba code for cutoff time
VBA
1 vote334 views1 answer
Add control vb
VBA
0 vote335 views1 answer
Type excel.application is not defined vb
VBA
0 vote342 views1 answer
Arq linux
VBA
0 vote358 views1 answer
Vba parameter adodb null value
VBA
0 vote318 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote365 views1 answer
Excel vba copy range with filter
VBA
0 vote319 views1 answer
Vba pass named range to function
VBA
0 vote363 views1 answer
Create links in msgbox in vb
VBA
0 vote346 views1 answer
Vba sheet hide unhide
VBA