Stop a '+' from generating a formula on googlesheet

I'm struggling with plus sign (+) . when I type a text begin with "+" on appsheet , I notice that corresponding cell on googlesheet  is turned to a formula  #ERROR!  !!!

I have this problem only with the sign (+) but in contrary the sign (-) googlesheet adds automaticlly an apostrophe ' to avoid turning the cell to a formula

I change the format of the sheet  from number to plain text but I still have same problem .

 

1 7 1,175
7 REPLIES 7
Top Labels in this Space