Forum Discussion

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
8 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
    8 years ago

    Hi purnima13,

     

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

     

    regards,

    L.Meijdam

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

purnima13 the problem is going to be some other text field possibly in your column are you sure its all decimals?  i dont see why there would be a problem converting,  otherwise there might be spaces trying doing a format  clean and trim in power query

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
8 years ago

vanessafvg: The only values in the file is what you see.
I have tried cleaning and trimming and it did not work