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