ENUM Populating Spreadsheet with ' before value

[Dougsterbob]

Hi all, 

I created an app for data entry only to speed up the process. Each column has an enum so I can go through and put in the correct values and input complete items into my main sheet quickly. But when I select these options and finish inputting the item... the values that it populates into the sheet have an ' in front of it. Which renders all of my equations useless. (like instead of 7, it inputs '7) how can I fix this??

When selected

What gets put into the spreadsheet

[Dougsterbob]

99% sure I just figured it out. The base type is TEXT and not NUMBER. I'm gonna change it and see if that solves it.