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 users+h...@libreoffice.org 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