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+unsubscr...@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