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.