I have been having an issue computing a percentage of a product price/cost and removing additional decimal places in the edit line. Our POS System will not accept Prices with more than 2 decimal places. I can remove them in the visible work area, but not the edit/command line. It becomes difficult when I have to manually go through and delete the extra digits when there are 400-700+ products. This was never an issue until recently. Example (Column/Row A1=19.99) and trying to compute price at a 20% discount. In box B1 (=A1*80%) (Answer= 15.992, which I then remove Formulas and format the result to “Number”). With older versions of Libre Office this was not an issue, but creates a LOTTTTTTT of extra work now when using Libre Office to upload products to our POS System server. The spreadsheet is uploaded with our server’s required Column Headings: “Category,Brand,Product,Price,Cost,Tax, etc…”. There is no problem if I simply have to enter price/cost, but I can no longer use it for sales. Using the Delete Decimal Place tool, Formatting the cell, and Paste Special will not solve the issue in edit line.
Is there a way around this?
Decimals Calc
I don’t understand the problem. If a formula =A1*80% calculates a value then the formula is shown in the Input Line, not the result value. And how would the value in the Input Line affect uploading data to your POS system? How do you upload your data anyway?
Please do not use the Answer field, edit your original question to provide further details. Thanks.
Hello erAck,
I edited for clarification:
"Example (Column/Row A1=19.99) and trying to compute price at a 20% discount. In box B1 (=A1*80%) (Answer= 15.992, which I then remove Formulas and format the result to “Number”). With older versions of Libre Office this was not an issue, but creates a LOTTTTTTT of extra work now when using Libre Office to upload products to our POS System server. The spreadsheet is uploaded with our server’s required Column Headings: “Category,Brand,Product,Price,Cost,Tax, etc…”
B1: =ROUND(A1*80%;2)
Awesome. That worked perfectly. Thank you so much
Also B1: =TRUNC(A1*80;2). LibreOffice Help on TRUNC.
Don’t forget to check the mark (
) to the left of the answer to show that your question was solved.