Forum Discussion

Anders Krogsager's avatar
Anders Krogsager
Copper Contributor
Aug 19, 2019

integer input is formatted as string

I am collecting integers greater than zero, but entries are prepended by a single apostrophe in excel.

Is this not a bug?

microsoft forms

7 Replies

Sort By
  • naspetti's avatar
    naspetti
    Copper Contributor
    Oct 16, 2019

    Anders Krogsager 

    I have a problem: the excel form generated my MS Forms, put an apostrophe before the number or text...so the pivot doesn't work... is it a bug? started few weeks ago!!

     

     

     

  • mrVazil's avatar
    mrVazil
    Copper Contributor
    Sep 24, 2019
    This is new behaviour that wasn't present a couple of months ago, I hope this is fixed soon. I import the values from the forms into access, and it crashes on the text fields that are supposed to be integers if I don't manually convert them first.
  • Deleted's avatar
    Deleted
    Aug 21, 2019

    To get rid of this issue need to apply the formula that is B3&":"&C3.

    This will not allow the integer to be formatted as a string.

  • JensSvensk's avatar
    JensSvensk
    Copper Contributor
    Aug 19, 2019
    I have the same issue. I want to present the collected data in a pivot chart. When I manually convert the data to number in each cell then the chart works. Must be some way to change the format of data when exported to Excel.

Resources