LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding bytes, gigabytes, and megabytes in Excel NetTech Excel Worksheet Functions 4 April 3rd 23 06:47 PM
Time and megabytes ACarella Excel Worksheet Functions 4 November 12th 08 01:07 PM
0 bytes andy Excel Discussion (Misc queries) 6 May 9th 08 01:28 PM
How many bytes? GARY Excel Discussion (Misc queries) 0 April 15th 06 09:31 PM
Add kilobytes to megabytes in the convert function Matt Thompson Excel Worksheet Functions 2 October 5th 05 04:20 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"