Correction Last line should read Save as *.ods file Regards, MalJaros ----- Original Message ----- From: "maljaros" <maljaros@icon.co.za> To: "Global Users@" <users@global.libreoffice.org> Sent: Thursday, 7 May, 2020 22:00:43 Subject: Fwd: [libreoffice-users] sum text column of common unit of measure numbers Hi James
My cell phone provider only provides me a CSV with a text field for the usage. I want to =sum( it so I need it to be numbers. Is a macro the easiest way to make a new column of common unit of measure (GB?) numbers? 15 KB 5 KB 10 KB 15 KB 5 KB 5 KB 5 KB 1.8 MB 5 KB 5 KB 15 KB 215 KB 130.2 MB 9.2 MB 475 KB 11.7 MB 10 MB 15 KB 12.1 MB 5 KB 10 KB 7.1 MB 5.3 MB 4.9 MB 15 KB 240 KB 130 MB 2.9 MB
I suggest the following procedure. Open the *.TXT file in CALC, ticking "Separated by" and "Space" boxes. Should produce spreadsheet with Numeric values in Column A and Text (either MB or KB) in column B. In Cell C1 put =IF(B1="MB",A1*1000,A1) Copy Cell C1 down to bottom of table. Save as *.odt file Regards, MalJaros -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy