How can I fix the numbers to show only 2 decimal points in the spreadsh

How can I fix the numbers to show only 2 decimal points in the spreadsheet to form.

The spreadsheet number is .67 but it shows .67155898999 (for example)

I have toggles the limt entry characters on but that did not work

I have limited the characters to 4 and that still did not work.

Also can you use this in a table format?

Thanks in advance

I assume that you are referring to the form: 200991470142854.

If this number is appearing in the uploaded sheet, then you will need to format the cell to adjust the decimal numbers.

OR are you referring to these fields which are auto populated when the spreadsheet to form field is filled?

If yes, how are these fields configured in the uploaded spreadsheet?

Please review and confirm.

Hi Gerard

Thanks for the response.

On the spreadsheet they are entered as numbers with 2 decimal points. Some are a result from a formula  i.e =e2/e3

So they appear on the spreadsheet as 0.69  but on the form it's .6959595959595 etc

It is on the form I want them to be only to 2 decimal places On the form 

So in the example above FC% would be 0.67 instead of 0.66994949494949

Thank you in advance

Wayne

Hello Wayne,

As far as I can see, the uploaded spreadsheet, should contain the cell data as values. If they contain the formulae (though you have formatted the cells to 2 decimals), the output on the form, will show the entire value (i.e. the general cell format).

So there are two options:

Option 1. The uploaded spreadsheet cells should not have the formulae

Option 2. Just copy the cost price and sell price into the form using the widget (i.e the cells which do not contain the formula) and do the rest of the calculation on the form itself using a Form calculation widget. On this widget, you can control the decimal places to 2.

Related Guide: How-to-Perform-Form-Calculation-Using-a-Widget 

If you need any assistance regarding the Form calculation, please let us know.

Thank you Gerard

I have used the calculation fields and have had success. Good work around.

Thank you for your help much appreciated, stay safe in this most unusual time in the world.

Kind regards

Wayne

Hello Wayne,

Glad to know that worked for you. If you have any further queries, do reach out to us.

Stay safe!