acekidpro
acekidpro
Programming language:VBA
2021-04-01 02:00:30
0
Q:

excel how to format bytes as KB, MB, GB

ClickRick
ClickRick
Code: VBA
2021-07-17 03:23:34 
'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"
1

Tags

Related

New to Communities?

Join the community