/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 vote232 views1 answer
Vbnet click on dgv cells
VBA
0 vote220 views1 answer
Excel vba extract year
VBA
0 vote249 views1 answer
Group controls programmatically vb
VBA
1 vote239 views1 answer
Excel vba array remove first
VBA
0 vote234 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote260 views1 answer
Vba registry settings
VBA
0 vote225 views1 answer
Vbscript abs
VBA
0 vote234 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote239 views1 answer
Vba word pdf table to excel
VBA
0 vote250 views1 answer
Selecttoken em vbnet e json
VBA