Exporting... CSV
"Screen Shot 07-18-18 at 04.00 PM.JPG","C:\Users\M\Pictures\My Screen Shots",1346808
How to set typical values in KB, MB, GB ???
example:
"Screen Shot 07-18-18 at 04.00 PM.JPG","C:\Users\M\Pictures\My Screen Shots",134KB
"Screen Shot 07-18-18 at 04.00 PM.JPG","C:\Users\M\Pictures\My Screen Shots",1MB
Exporting... CSV How to set typical values in KB, MB, GB ???
-
- Posts: 531
- Joined: Thu Jan 26, 2017 11:56 am
-
- Site Admin
- Posts: 4968
- Joined: Fri Oct 16, 2009 11:31 pm
Re: Exporting... CSV How to set typical values in KB, MB, GB ???
Everything currently only exports sizes in Bytes.
I'll consider an option to export sizes as KB, MB or auto (Bytes/KB/MB depending on size).
For now, you may like to use Excel to convert the size to KB or MB.
I'll consider an option to export sizes as KB, MB or auto (Bytes/KB/MB depending on size).
For now, you may like to use Excel to convert the size to KB or MB.
-
- Posts: 150
- Joined: Sat Oct 27, 2018 11:33 am
Re: Exporting... CSV How to set typical values in KB, MB, GB ???
If anyone interested, here's a formula for Spreadhsheet
Assuming Size is in 4th column (D) and data starts on 2nd row
Can someone fine tune this pls.
Assuming Size is in 4th column (D) and data starts on 2nd row
Code: Select all
=IF(D2>1099511627776, ROUND(D2/1099511627776,2) & " TB",IF(D2>1073741824, ROUND(D2/1073741824,2) & " GB",IF(D2>1048576,ROUND(D2/1048576,2) & " MB",IF(D2>1024,ROUND(D2/1024,2) & " KB",D2 & " B"))))