Conversion function for Bytes
 

It seems rather unbelievable that Excel does not have nor has anyone made a
conversion function or tool for MS Excel that allows you to convert Bytes to
KB, MB, GB, and / or TB.

As an IT person, I would find this most helpful when creating reports on
file sizes and disk utiliization.

Yes, I know I can use thhe rather cludgy methode of multiple multiplications
or diviions of a given number to represent or approximate these values, but
come on, there has to be a function for this? Yes?

Here is to hoping someone has something better.

Answer: Conversion function for Bytes
 

Hi there! I completely understand your frustration with the lack of a built-in conversion function for Bytes in Excel. However, there is a way to create a custom function that can do the conversion for you. Here's how:

1. Open a new or existing Excel workbook and press ALT + F11 to open the Visual Basic Editor.
2. In the editor, go to Insert Module to create a new module.
3. In the module, paste the following code:
   
   
   Formula:

   ---

   Function ConvertBytes(ByVal bytes As Double) As String
    Select Case bytes
        Case Is <= 1024
            ConvertBytes = bytes & " Bytes"
        Case 1024 To 1048575
            ConvertBytes = Format(bytes / 1024, "#0.00") & " KB"
        Case 1048576 To 1073741823
            ConvertBytes = Format(bytes / 1024 ^ 2, "#0.00") & " MB"
        Case 1073741824 To 1099511627775
            ConvertBytes = Format(bytes / 1024 ^ 3, "#0.00") & " GB"
        Case Is = 1099511627776
            ConvertBytes = Format(bytes / 1024 ^ 4, "#0.00") & " TB"
    End Select
End Function 


   ---

4. Save the module and close the editor.
5. Now you can use the function in your worksheet. For example, if you have a file size in Bytes in cell A1, you can use the formula =ConvertBytes(A1) in another cell to get the size in KB, MB, GB, or TB.

Conversion function for Bytes
 

You could do it quickly enough with formulas.

Bytes to KB
=A2 / 2^10

Bytes to MB
=A2 / 2^20

KB to bytes
=A2 * 2^10

etc.

To make it smoother, you could define a name (Insert - Name - Define), like KB, defined as
= 2^10

Now to convert something to KB:
=A2 / KB

Or to MB:
=A2 / KB / KB

Or to terabytes:
=A2 / KB / KB / KB

Or KB to bytes:
= A2 * KB

You could also define a a name like MB:
= 2^20
instead of using KB twice.

Stuff like that.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"RORWessels" wrote in message
...
It seems rather unbelievable that Excel does not have nor has anyone made a
conversion function or tool for MS Excel that allows you to convert Bytes to
KB, MB, GB, and / or TB.

As an IT person, I would find this most helpful when creating reports on
file sizes and disk utiliization.

Yes, I know I can use thhe rather cludgy methode of multiple multiplications
or diviions of a given number to represent or approximate these values, but
come on, there has to be a function for this? Yes?

Here is to hoping someone has something better.