/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

1 vote166 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote171 views1 answer
Excel vba disable keyboard input
VBA
0 vote178 views1 answer
Excel vba copy entire sheet paste values
VBA
20 votes366 views1 answer
Excel vba factorial
VBA
0 vote166 views1 answer
Enter into cells data grid view
VBA
0 vote174 views1 answer
Nested if else in vb.net
VBA
0 vote121 views1 answer
How to sort datagridview in vb.net
VBA
6 votes195 views1 answer
Excel vba isalpha
VBA
0 vote187 views1 answer
Vba integer to double
VBA
0 vote159 views1 answer
Le contrôle SpinButton (Toupie)
VBA