Convert KB to MB and GB
Are your values in bytes or kb or mb or gb?
If the values are in bytes, you can sum all of them and divide by:
1024 to get kb
1024*1024 to get mb
1024*1024*1024 to get gb
This is not the marketing formula. They use 1000 instead. So it sounds like
harddrives have more space than they really do.
Chrischik wrote:
Hi all,
I'm doing a clean up of some shared drives and am trying to quantify the
amount of disk space save.
Some files are small and only 200 KB, others are 300 MB and some folders are
even in GB. Is there a way that excel can count KB/MB/GB and convert into one
GB sum?
I'd appreciate any help.
thanks,
Chris
--
Dave Peterson
|