Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
98
Views
Topic starter
How could I covert the number saved in text into number format? I have tried everything.
I have attached the file
Posted : 30/01/2020 5:24 pm
Hi Sheikh,
Welcome to our forum. That's a tough one. I can see there are two extra characters at the front of the text but I couldn't remove them using the Replace tool. If you split the column by number of characters and enter 2 for the number, it correctly converts the column to a number format and you can delete the empty column that remains.
Mynda
Posted : 31/01/2020 3:26 am
Topic starter
Thank you so much
Posted : 31/01/2020 8:54 am
