LibreOffice Base - Table - Column Format - Currency - Won't register decimal correctly

[AripSon]

I use this format for payment.value column = [$RM-43E]#,##0.00;[RED]-[$RM-43E]#,##0.00

I have set the decimal place to be 2.

I have entered value of $297.67. But LibreOffice Base automatically records as only $297.00.

My database shall not be correct. An unaccountable amount of $0.67 has not been registered should a query report is made.

Please help me with a solution.

[Ratslinger]

The format for a field in a table has nothing to do with how it is stored. You must have the correct Field Type, Length, and Decimal places defined and the saved amount will be correct:

If you have an incorrect field type (such as Integer) or the number of decimals in Field Properties is not set correctly, no matter what format you use it will not work.