/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 vote170 views1 answer
Vba set vs dim
VBA
0 vote230 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote277 views2 answers
Excel vba store array and write to sheet
VBA
0 vote192 views1 answer
Vbide vbproject reference
VBA
0 vote242 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote225 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote232 views1 answer
Vba get relative cell address
VBA
1 vote223 views1 answer
How to check is the value enterd is a number or text in vba
VBA
1 vote173 views1 answer
Ms access open form to new record
VBA
31 votes277 views1 answer
Vba how to convert a column number into an Excel column
VBA