Forum Discussion
Solved
Convert text to pourcentage
Hello everybody, How to convert a value with type text in pourcent? Thanks 🙂
We just had to replace the empty cells with null 😉
it looks like this:
- tamerj1
Community Champion
I tried from my end and Power Query automatically converted the text to number without me even doing anything. Make sure to check if you have some cells that contain letters or hidden special characters. You may also try Tranform - Trim and Trasform - Clean if you cannot see any visible character.
FreemanZSuper User
hi hendraoui
it looks like you have data from a specific locale, like Germany.
try to
1) right click the column, choose Change Type -> Using Locale, choose Decimal Number and English(Germany), and OK to close.
2) change it to percentage as usual.
We just had to replace the empty cells with null 😉
