/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

4 votes346 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote310 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote288 views1 answer
Excel vba formatconditions positive
VBA
3 votes290 views2 answers
Excel "vba" match last value
VBA
0 vote282 views1 answer
How to make a a msgbpx in vbs
VBA
5 votes316 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote311 views1 answer
Regex numeric digits
VBA
0 vote274 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote286 views1 answer
Internet explorer reference vba
VBA
0 vote306 views1 answer
Vba open report
VBA