Question

Convert text into numbers in Google Sheets

  • 3 December 2021
  • 5 replies
  • 229 views

Userlevel 1

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


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +14

Hi @SerrePipe 

Check this help article: https://support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop

Userlevel 7
Badge +11

Hello @SerrePipe and welcome to the Community! :)

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?

Userlevel 1

Thank you all for your answers. 

 

@SamB I’ve tried both, I’ve selected the entire column and also just the cell, both case number stay as text. So i cant do any addition or multipication with them..

Any other clue ?

Thank you again for your help

Userlevel 7
Badge +14

@SerrePipe 

A 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)

Userlevel 1

I’ve resolve partially my problem by making a mirror of the column. In the copy, numbers appears normally and I can addition them.