Jan 24 2020 03:34 AM
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 is €.
How can i deal with that ? help please.
Jan 24 2020 03:40 AM
Jan 24 2020 03:44 AM
Jan 24 2020 03:50 AM - edited Jan 24 2020 03:50 AM
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.