Thousands separators not replaced

Question

I use Studio 2017 Freelance. 
 
 My thousands separators are not being replaced. It is FR>EN, so it should replace periods with commas (e.g., 2.500.000 > 2,500,000). The thousands figures are NOT underlined in blue. But they do appear when I hit ctrl-comma. They just remain as they were in the source. 
 
 I use Studio 2017 Freelance.

My thousands separators are not being replaced. It is FR>EN, so it should replace periods with commas (e.g., 2.500.000 > 2,500,000). The thousands figures are NOT underlined in blue.* But they do appear when I hit ctrl-comma. They just remain as they were in the source. 
 
 *The "numbers" box IS ticked in the project settings for Auto-substitution. 
 
 My decimal separators are working fine (they're underlined in blue and 2,0% becomes 2.0%).

If anyone can help I'd certainly appreciate it. 
 
 Tom Weber

Paul · Answer

Hi Thomas Weber , 
 The problem is that Windows (and therefore Studio) consider the thousands separator for French to be a space. If you change all your numbers so that the thousand separators are a space then it will work correctly. I'm not sure what the correct ways to write these in French is, but a simple google around suggests that they should be a space and not a period. 
 You can use the SDLXLIFF toolkit to change the source numbers in your files so the thousands have a space instead of a period, or make the changes in the original source file. 
 https://multifarious.filkin.com/2013/09/25/the-sdlxliff-toolkit/ 
 https://multifarious.filkin.com/2017/01/14/revisiting-the-toolkit/ 
 I'm pretty sure that once upon a time you could also change the regional settings in windows to resolve this issue, but this doesn't seem to work anymore. So I think your only option is to change the source, either in the SDLXLIFF or in the original source file. 
 Regards 
 Paul

Trados Studio > 1. Trados Studio

Thousands separators not replaced