Copy your data into a txt file. Open with your spreadsheet, separate by space to put numbers in Col A and Kb/mb in Col b. Col c = A1*1000 to get total kb. The sum up the whole thing. Divide the total by 1000 to get mb. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Thu, May 7, 2020 at 2:05 PM James <bjlockie@lockie.ca> wrote:
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 -- 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