Why are Negative numbers shown as text rather than numbers in excel sheet?

  • Profile Image
    shoefactorybelleville
    Asked on February 06, 2018 at 12:04 PM

    Hi,

    I have setup forms which autopopulate to a gmail doc spreasheet.  Calculation fields the are negative come over as text, rather than a number, causing error in my form calculations

    Michael


  • Profile Image
    TREVON
    Answered on February 06, 2018 at 02:11 PM

    I tested downloading and excel sheet of form submissions of the form 72133313523242 and as shown below I could not replicate the issue you are experiencing.

    I was able to perform form calculations even of the negative values as shown.

    1517944285caclculation excel.png

    Would you kindly recheck that you are performing calculations on the correct fields and that the fields are Numeric?