View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toney Toney is offline
external usenet poster
 
Posts: 18
Default Convert bytes to kilobytes or megabytes?

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