/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 vote375 views1 answer
Send text to clipboard vb.net
VBA
31 votes516 views1 answer
Vba how to convert a column number into an Excel column
VBA
1 vote308 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote380 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote366 views1 answer
Vba first cell in range
VBA
0 vote369 views1 answer
How to use if condition in time vba
VBA
0 vote356 views1 answer
Excel run macro every 5 minutes
VBA
0 vote366 views1 answer
Vba range clear formatting
VBA
0 vote363 views1 answer
Vba get workbook name
VBA
0 vote391 views1 answer
Excel vba first working day month
VBA