View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default 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.