# Adding Row to A Sheet places a single quote in front of Numeric value

**URL:** <https://community.glideapps.com/t/adding-row-to-a-sheet-places-a-single-quote-in-front-of-numeric-value/40069>\
**Category:** Ask for Help\
**Created:** [March 25, 2022, 5:49am UTC](https://community.glideapps.com/t/adding-row-to-a-sheet-places-a-single-quote-in-front-of-numeric-value/40069 "2022-03-25T05:49:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\
**Post date:** [March 25, 2022, 5:49am UTC](https://community.glideapps.com/t/adding-row-to-a-sheet-places-a-single-quote-in-front-of-numeric-value/40069/1 "2022-03-25T05:49:49Z")

</div>

I have a button that adds a row to another sheet. One of the fields sets to a constant of “1”(numeric one). I have the precision of that column set to “1”

The value in the cell of the destination sheet is " '1 " (preceding single quote). The FILTER formula that addresses this value then fails becasue the value is not numeric. Column is formatted to numeric precision o.

I had the same problem with Time Only fields but thought that was just peculiar to time fields. I wrote a function in app scripts to reformat on Edit to fix that. But it seems this problem is deeper.

Any views?