New Bug Encountered: Apostrophe add to my key

[Stephens_Utilit]

Hi!,
When I add a new row to [Job] an extra character is added to text in a column, [Cusotmer ID]. In the app i select a customer by name, and the app fills in the customer info such as customer ID. That column for customer ID that is used to pull data into the sheet via a Vlookup sheet formula. Because that character is in the, the vlookup returns “Error” in multiple fields.

Its adding an apostrophe before customer ID

[Steve]

I’d guess the spreadsheet column type is not plain text or Automatic. Is that the case?