The thousands separator does not appear.

Hello Ian,

I thought you were of English origin, I was a little too quick in my deductions.

I had looked in the French and English communities only for subjects concerning this problem and I did not see much conclusive.

As I write, I made a request for evaluation at Apple on May 24 in French.

As I've two accounts for communities, one for French and the other for English. I made a mistake.

I posted a thread in English on French Community on 11 may and I received a message yesterday from Elise115 (not SGIII aka SG) on 2 june asking me to create a thread on the English Community in English or French Community in French.

That's what I did but I melted the emails from Apple Communities about SG. Excuse me SG.

Explaining the rest of the story does not seem to please everyone.

I know very well what the purpose and role of these communities is and I do not need to be told that again. But we can not help but say and believe that these communities are completely ignored by Apple and development teams and fortunately.

Obviously, there is a bug, we will wait for the next version to find out if Apple has found a solution.

Ian, I am also very often read-only on these communities (French and English only).

See you soon.

Bertrand

Hello SG,

I'm on a French MacOS and all my settings are set to French region.

If I go to File>Advanced>Langage & Region, I see the same thing that you show upper but in French and settings for MacOS are same in French.

I report to Apple at Numbers > Provide Numbers Feedback but someone named SGIII ask me to transfer this report here on Apple Communities Discussions.

It make nonsense to redo such a report.

There is a bug and Apple must give some help or change to this.

Bertrand

SGIII aka SG as you appear at beginning of each message you write,

I appear as Bertrand (Fr) aka Bertrand

I use Apple products since 1981 with Apple ][ and Mac since 1985 so I hope to know well OS Systems, OS X systems and macOS systems, ClarisWorks, iWork and Numbers.

I never use any other office software than Pages, Numbers and Keynote.

The only thing I've not done is switching my Mac to US and redo what I've done multiple times with System preferences and File Advanced settings.

You can also see in this thread that Yellowbox aka Ian, has the same problem in Spanish https://communities.apple.com/es/thread/250737765

I think that he first answer you gave me by mail comes from Apple evaluation tool with message number — FB7712823. In this mail, you suggest to lead a thread here. When I've used all tools from macOS or software preferences or read all forums speaking of my problem I use evaluation tool and not Users Communities I've all ready read in French and in English. ( I don't speak Spanish Ian :) )

I can use this tool because I'm also beta tester for macOS, iOS and iPadOS and have also an Apple developper status.

But this doesn't give a solution to my problem of format in Numbers because nothing can show to me that this problem is under study by Apple teams.

Bertrand

Ian,

hello que tal :)

I try to switch to Spanish and can see what is describe in the thread that you mention. Under 9 999, separator is not set or shown, up to 10 000, the separator is set or shown.

In French setup, from 0 to infinity, the separator is not set.

I kwow also that this only concern how numbers are displayed and I'm not afraid about the value of numbers in cells.

Bertrand

Hello Barry,

no need to remember the spirit of the communities, I don't think I have transgressed it.

I have known these user communities for a long time, I know that Apple is only making this forum available to users, but nothing will prevent me from believing that Apple's teams do not read them, without intervening, so as not to not violate the rules of user communities. They know very well how to contact me if they want to, as they have done several times following reviews on macOS.

It is like the reviews on Google or Trip Advisor, they are user reviews but nobody prevents the suppliers from reading these reviews and even from responding to them.

I am French and English is not my first language, so maybe I don't use the exact words to say or what I want or tell what I read, I don't have a dictionary and a grammar in the head. (For this message, it will be translated by Google Translator, you will have to be content with it and understand the subtleties of Google Translator)

Ian certainly understood what I wrote (I've read his response and without what he wrote, I can't guess he was living in Australia, can speak English and what he says about this problem or indicates threads to read). Whether or not he is a victim of this problem, I could see it and after having made other tests inspired by this thread in Spanish, I can confirm what this thread reports and indicate what is happening with the French version from Numbers.

I am simply surprised that someone identified as SGII (aka SG) contacted me by email following my evaluation request N ° FB7712823 of May 24, 2020 on Numbers and advised me to ask a thread on this community what I have done. I had not seen anything concerning this problem on the French and English or American communities before. Sorry, I don't speak Spanish and very little German. So I asked for an evaluation on Numbers in the appropriate tool.

That said it does not solve my problem, if no one has a solution, it does not matter, it is only an aesthetic problem.

We can only hope that the future version of Numbers will be modified according to what Users report on this thread, when we promise something, we keep our promise. I'll be waiting the next delivery. If no solution, I'll post a new evaluation.

Bertrand

Hi Ian,

Merci pour le Français.

Thanks for French.

This goes well for an English doc "translated" to French with Numbers in English (macOS English) when changing File>Advanced settings, but not for a French doc with Numbers in French (macOS French).

Bertrand

Ian,

Je pense que le fait d'avoir pris un modèle fourni par Numbers est la cause de ce problème et qu'il est irréversible.

Cela fait un certain temps que je me dis que passer mon Mac en anglais résoudrait bien des problèmes de ce genre mais c'est épuisant d'être toujours en mode traduction.

J'ai aussi des problèmes de ce type avec mon logiciel de généalogie MacFamilyTree qui s'amuse à traduire les dates en format américain quand le jour et le mois sont inférieurs à 13. Ainsi 08/06/1953 devient 06/08/1953 sans que je ne fasse rien, sauf ouvrir et fermer le fichier. Mon anniversaire est en juin, pas en août. :)

The same in English :

I think that having taken a model provided by Numbers is the cause of this problem and that it is irreversible.

I've been thinking for a while that switching my Mac to English would solve many of these problems, but it's exhausting to always be in translation mode.

I also have problems of this type with my genealogy software MacFamilyTree which likes to translate the dates in American format when the day and the month are lower than 13. Thus 08/06/1953 becomes 06/08/1953 without that I don't do anything except open and close the file. My birthday is in June, not August. :)

Bertrand

Ian,

reading threads about this problem, I have found no solution.

I'll wait next version of Numbers and stay listening this thread.

I'm retired since 5 months but I must work with FileMaker and follow some affairs with numbers.

Perhaps the stairs will provide some response. :)

Bertrand