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
Solved! Go to 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.
@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.
@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.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |