Forum Discussion
Currency Changes
Hi everybody ! I have a little problem. I get a csv file in which the currency is $. I try to transform the column in number format but it doesn't fit. I think the default currency of my excel i...
What do you mean "it doesn't fit"? Excel can't tell the currency of the amounts in a csv. Even if the amount comes in as "$100,000", it will be seen as a text. You need to get rid of the $-sign, probably also the comma. Only then you will have a number that you can format with a $-sign.