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

Back to all questions

US Excel Vs Fr Excel

9 months ago
Vote Up Vote Down
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 8 months ago
Vote Up Vote Down
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

You must to answer this question.
JanuaryPromo
×
Complete Data Science Education
Get 50% OFF