to convert kb to mb, divide by 1024, to convert mb to gb, divide by 1024
How is the size data entered in excel, if the number is in one column and
the GB/KB/MB in another, you can use IF statements to see what you have to
divide by, or multiply by. If it's all in one cell, you can use LEFT and
RIGHT statements to seperate the number from the rest.

"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