New Bug Encountered: Value written to google sheet starts with apostrophe( ' )

[Heino_Matthee]

I have an expression to write the batch number to google sheets which I use for various references of text type and if I test the expression it does not have the apostrophe, it only gains the apostrophe when written to google sheets. Is this expected behaviour I should work with or can I remove it? TIA

Edit: It’s hard to see but in the sheet the batch number is '310819001

[LeventK · Accepted solution]

@Heino_Matthee
Your BatchNo_ID column is a text type column but consists of numbers only. That’s how gSheet differentiates text from numbers. It does no harm.

[LeventK]

@Heino_Matthee
Check out this:
The number in [A1] is a number figure, but the numerical figure in [B1] is typed with apostrophe and as you can see they are not equal.
The same number in [A2] but the cell is formatted as Plain Text (when you format a numerical figure as plain text, gSheet automatically recognizes it as text and therefore removes the apostrophe) and the numberical figure in [B2] is same than [B1] and they are equal.