Bill As is the usual I rushed to help before I read all of the posts. I am glad that you have found the solution to your question. I did not. My csv file brings the field in as text because the smartphone exports the field as text. I did some testing and found the following: 1 In the Text Import dialog box I set the Seperated By to Comma and the Text Delimiter to Apostrophy (not sure why this is the way it has to be but it is) 2 Select the Other Options, Quoted Fields a Text (This will put " around the data in the sheet that is text) 3 Once the sheet is open I do a Find & Replace with Regular Expressions turned on to Find "*" and Replace with *. This replaces all of the " with *. 4 Then Find * and Replace with (nothing) to get rid of the * and the numbers in the field are now numbers instead of text. This solution is not as clean as yours but it got the job done. John McAtee
From: bill woodruff <[email protected]> To: [email protected] Cc: Sent: Saturday, November 6, 2010 9:07:04 PM Subject: [libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work plino <pedlino <at> gmail.com> writes: > > > Bill, do the cells in the range contain only natural numbers? > > I suspect that you are having a problem with the decimal separator. > > Your cells are probably identified as text because of that (are the values > aligned to the left?) > > Paste this in cell D2 to check > =VALUE(C2) > Hello, Plino: This is a second reply. After I wrote you earlier, I tried re-importing the .csv file. This time, I clicked on the "Standard" heading on top of the column in question, hoping there would be a format for "Currency." There was none, but after I clicked "Hidden" then clicked back to "Standard," the file imported with the currencies properly recognized and aligned to the right. Now the =SUM(c2:c46) function works just fine. I am sorry for wasting so many people's time, but I could not figure this out by myself. I am very grateful to everyone involved for their suggestions. One final question: Shouldn't the Import function recognize currencies automatically rather than making the user jump through these hoops? Sincerely/Bill Woodruff -- E-mail to [email protected] for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted -- E-mail to [email protected] for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
