/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 vote155 views1 answer
Excel vba arrondir
VBA
0 vote186 views1 answer
Excel vba urlmon
VBA
0 vote195 views2 answers
VB
VBA
0 vote166 views1 answer
Vbnet check if sting contians symbols
VBA
1 vote169 views1 answer
Add control vb
VBA
3 votes185 views1 answer
Extract word in a text in excel
VBA
0 vote178 views1 answer
Vba table header name
VBA
5 votes175 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
-1 vote177 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote179 views1 answer
Set column width of datagridview vb.net
VBA