-
waynelaidlawAsked on April 9, 2020 at 8:03 PM
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
-
Girish JotForm SupportReplied on April 9, 2020 at 9:56 PM
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.
-
waynelaidlawReplied on April 9, 2020 at 10:02 PM
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
-
Girish JotForm SupportReplied on April 9, 2020 at 11:29 PM
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.
-
waynelaidlawReplied on April 10, 2020 at 4:43 AM
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
-
Girish JotForm SupportReplied on April 10, 2020 at 6:13 AM
Hello Wayne,
Glad to know that worked for you. If you have any further queries, do reach out to us.
Stay safe!