voidtools forum

Posted: **Sat Jan 12, 2019 7:43 pm**

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

Posted: **Mon Jan 14, 2019 8:10 am**

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.

Posted: **Mon Jan 14, 2019 10:15 am**

If anyone interested, here's a formula for Spreadhsheet

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

Can someone fine tune this pls.

voidtools forum

Exporting... CSV How to set typical values in KB, MB, GB ???

Exporting... CSV How to set typical values in KB, MB, GB ???

Re: Exporting... CSV How to set typical values in KB, MB, GB ???

Re: Exporting... CSV How to set typical values in KB, MB, GB ???