andreasvesalius
New Member
- Joined
- Sep 23, 2005
- Messages
- 5
I have a column that contains data of file sizes in bytes. I wat to convert it automatically in Kilo or Mega bytes if the number is greater than 1024 or 1024 x 1024 respectively.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Bytes | Conversion | ||||
2 | 500 | 500 bytes | ||||
3 | 1,020 | 1020 bytes | ||||
4 | 1,024 | 1024 bytes | ||||
5 | 50,000 | 50 kb | ||||
6 | 1,048,575 | 1048.575 kb | ||||
7 | 1,048,576 | 10.48576 mb | ||||
8 | 2,500,000 | 25 mb | ||||
Sheet1 |