Number data in google sheet display as mix of number + letter (182818E200)

Number data in google sheet display as mix of number + letter (182818E200)
Example :
I add this number in gsheet : (10 number)
1831929388
If i want to export the sheet to csv or copy text to excel…
The number display : 183192E29388
Is it possible to fix this problem in kodular community ?

You mean, Is app showing wrong value instead of correct one? Did you set cell format as plain text in gsheet?

1 Like

No I mean the sheet in google sheet if i try to export it as csv or copy only one barcode to excel… The format of the number replacd…
This problem occur with barcode data (contain 10 number) so if i want in future to export or copy one full column to excel file… The data number that copied from gsheet will be in different number (related to format) so the app will not display any result if user check the barcode drug he want…

How to set the cell formate?

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.