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

  • shoefactorybelleville
    Asked on February 6, 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


  • TREVON
    Replied on February 6, 2018 at 2: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 Screenshot 10

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