Forum Discussion

rafaelsmoreno's avatar
rafaelsmoreno
Frequent Visitor
8 years ago

Changing Data Type problem - Financial numbers stored as text won't convert to currency

Hello everyone,

 

I got a column from a data set in which the Amounts of the Journal Entries are stored. Power query didn't recognize it as number, and kept it as text. Whenever I try to apply convert to currency the operation works, however numbers get messed up, e.g.: 435,97 will become 43597. 

Any ideas on how to solve that?

I tried Replace.Value with Number.FromText and it hasn't worked either. 

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    If i had to guess, its possibly a language settings issue.  I know under my language settings that a number 435,97 would be expected to have been stored as 435.97 instead, however if it saw 435,97 it would drop the comma as typically those are used to separate numbers from purely a display aesthetic (typically to break up thousands, millions, billions etc)