/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

2 votes223 views2 answers
Excel vba if sunday or staurday
VBA
1 vote219 views1 answer
Extract the second word in a text in excel
VBA
0 vote219 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote213 views1 answer
Vba sort multiple columns
VBA
0 vote220 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote205 views1 answer
Make all controls in an area not visable vb
VBA
0 vote198 views1 answer
Hello world vb.net
VBA
0 vote248 views1 answer
Vba ternary
VBA
1 vote223 views1 answer
Vba optional
VBA
1 vote195 views1 answer
Textbox find and replace vb
VBA