Hi there,
Do you know hoe to convert text into numbers in Google Sheet ?
I try to export orders from Woocommerce to GS, in rows, but number are converted automatically to text, so i can not manage numbers in GS !
I’ve tried to switch format in GS, i’ve tried to numerous filter, but it end it stay text and not number.
Thank you so much, i’ve search in forum and on google and coulnt find any answer to this basic problem.
Regards
+14Hi
Check this help article: https://support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop
+11Hello
This type of issue, where the format changes, can occur if the format we’re sending to Google Sheets is different to the format within the spreadsheet.
You mentioned that even after you change the format in Google Sheets it still stays as text and not a number. When you changed the format did you select the entire column of cells or just the ones that already had a value in them?
If it was just cells with an existing value in them that were selected, then any subsequent rows that were added would have continued to have the previous text format, as they would not have had their format settings changed. Do you think that might have been the case here?
Thank you all for your answers.
Any other clue ?
Thank you again for your help
+14A possible workaround is to use a different app such as Airtable: https://zapier.com/apps/airtable/integrations#triggers-and-actions
Airtable is a relational database and has defined field formats. (e.g. Number: https://support.airtable.com/hc/en-us/articles/360021586274-Number-field-type)
I’ve resolve partially my problem by making a mirror of the column. In the copy, numbers appears normally and I can addition them.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
