Forum Discussion
Helper VUnknown icon before number
Hi,
Does anyone know what the icon is that I see before the number and how would I go about removing it? It's currently showing as a text but when I look to change it to a whole number in Power Query, it just returns "error"
Hi M_SBS_6. This is a currency sign, you can remove it using replace method in Power Query M. Copy any value that contains this currency, navigate to the column that contains this value, right click on the column and click on replace values. Hope it helps!
2 Replies
AbhinavJoshiResponsive Resident
Hi M_SBS_6. This is a currency sign, you can remove it using replace method in Power Query M. Copy any value that contains this currency, navigate to the column that contains this value, right click on the column and click on replace values. Hope it helps!
- Idrissshatila
Super User
Hello M_SBS_6 ,
It seems that its coming with the data, but you can extract the numbers only.
check this solution to see how to extract https://community.fabric.microsoft.com/t5/Desktop/Extract-text-from-the-middle-of-a-string/td-p/579898
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
