Forum

Error - Formatting ...
 
Notifications
Clear all

Error - Formatting Text as Value in Power Query

2 Posts
2 Users
0 Reactions
117 Views
(@airball)
Posts: 19
Eminent Member
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
(@mynda)
Posts: 4762
Member Admin
 

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
Share: