Convert bytes to kilobytes or megabytes?
=IF(A5<10^3,A5&"
bytes",IF(A5<10^6,ROUND(INT(A5/10^3),-1)&"k",ROUND(INT(A5/10^6),1)&" megs"))
--
__________________________________
HTH
Bob
"Toney" wrote in message
...
I have a list of files that include the file size listed in bytes. I need
to
convert these files sizes into Megs or K's or leave them as bytes. For
example what I have is...
File name Size in bytes
Tiny file 3
Medium file 153,600
Large file 5,242,880
What I need is...
File name Size
Tiny file 3 bytes
Medium file 150k
Large file 5 megs
Any ideas?
Thanks in advance
Toney
|