/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 vote218 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote270 views1 answer
If statement vdhl
VBA
1 vote225 views1 answer
Highlight selected cell in excel vba
VBA
0 vote179 views1 answer
Vbide vbproject reference
VBA
3 votes253 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote286 views1 answer
Vba excel do not recalculate before save
VBA
0 vote264 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote222 views1 answer
Vb check if row has column
VBA
0 vote232 views1 answer
Nested if else in vb.net
VBA
1 vote227 views1 answer
What does vbs stand for
VBA