/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 vote169 views1 answer
Perform http request in vb.net
VBA
1 vote152 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote183 views1 answer
Amd64 vs arm64 linux
VBA
0 vote194 views1 answer
Vba ternary
VBA
0 vote146 views1 answer
Openfiledialog specific folder
VBA
8 votes272 views1 answer
Vba convert 2 bytes to an integer
VBA
13 votes284 views2 answers
Vba write text file
VBA
0 vote157 views2 answers
Vba remove line breaks
VBA
0 vote118 views1 answer
How to make a if statement with vbs
VBA
1 vote144 views1 answer
Excel vba make cell visible
VBA