Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.