Ask Your Question

# Revision history [back]

It sounds like the data is text rather than numeric.

Instead, format the cells for currency, as described at https://help.libreoffice.org/Calc/Cells_in_Currency_Format. Then enter the values as a currency number.

A quick way to do this is Edit -> Find & Replace to remove all of the $. It may help to expand Options and uncheck Regular Expressions. This question was also answered at https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=38535. It sounds like seems the data is text rather than numeric. Instead, format the cells for currency, as described at https://help.libreoffice.org/Calc/Cells_in_Currency_Format. Then enter the values as a currency number. A quick way to do this is Edit -> Find & Replace to remove all of the $. It may help to expand Options and uncheck Regular Expressions.

This question was also answered at https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=38535.