Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I keep getting this error: DataFormat.Error: We couldn't convert to Number. I actually want it to sh

I'm having a slight issue with converting numbers into text and back. Half of my Microsoft Forms is both text and numbers

 

Here are some examples

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    Hi Anonymous 

    Some records contain numbers and strings (411- Prototyping & Tooling). Check the source and correct them

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi and thank you very much. This wasn't the solution I was looking for as the data is coming from a live Microsoft Form that I don't necessarily own myself

      • aj1973's avatar
        aj1973
        Community Champion
        3 years ago

        You do some cleaning in Power Query then, like Split after delimiter "-". you should then have a column with numbers Format.