Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
117
Views
Topic starter
I imported a text file (.txt) as a query but cannot format the number values from text to decimal or whole number after I have trimmed the white spaces. Locale is not working either. It prompts an error that "data cannot be converted to numbers". How can I get it right?
Posted : 23/10/2018 6:02 am
Hi Amien,
Sounds like there might be the odd cell that contains text values, not just numbers. Can you share a sample Excel file so we can take a look?
Mynda
Posted : 23/10/2018 8:19 pm