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 ???
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.
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"))))