The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

US Excel Vs Fr Excel

US Excel Vs Fr Excel

0
Votes
1
Answer

Hi,
I have a format problem regarding the number. I have a French Excel version and the exemple in the course does not work in the French version. I can’t change the region on Excel as it is a company laptop.
For example, the custom format $#”,”###,,, “M” that should remove the last 6 digit of a number (e.g. 6 595500,000 becomes $6,595 M with this format) does not work at all on the French version. I got $6595,500,,,M
I try to find on internet how to fix it and I have not found anything. It is not the only format problem regarding the courses examples I have.
As someone a clue about it?
Thanks
 

1 Answer

365 Team
0
Votes

Hi!
Well, in this case my recommendation would be to replace the comma sign with a dot sign (which should be the 000s separator in your language) and see if this works.
Best,
Ned

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF