Forum Discussion

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
9 years ago
Solved

Can't convert text to decimal

I have put the following values in a google doc: The column is formatted into number in the google doc   latitude 7.4064 7.6904 7.6904 5.3627 7.6904   I am however unable to...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi purnima13,

     

    Could you try to replace the "." for a "," and see if that helps ?

     

    regards,

    L.Meijdam

Johannf78's avatar
Johannf78
Icon for Advocate I rankAdvocate I
3 years ago

Left-click on the heading of the column you want to convert from text to decimal. Click on the icon indicating the data type. Then instead of clicking on "1.2 Decimal value" click on the last item "Using Locale..."  From the Data Type drop-down list select "Decimal Number". From the Locale drop-down list select  "English (United States)". Only this locle works, the outers does not.