[munch117]

What I used to do is set the thousands separator to ' in the operating system settings. That made Excel read CSV files with 1,004 and 1.004 the same, as one and four thousands. No one puts thousands separators in CSV files anyway, so that worked out. And it looked nice too.

In today's Windows 11 I can't find that setting. You can't set the thousands separator separately, not anywhere that I can find. It's a tragedy. I see Excel misreading CSV files all the time. I don't use Excel that much myself and I understand what's going on, so it doesn't affect me all that much directly, but for my Excel warrior colleagues, it's another matter.

[withinboredom]

You have to set it for the whole OS... it's like someone who works at Microsoft decided that you should never work on a file generated in a different locale.

[Dwedit]

If you need to apply a setting like that to a single application only, there are ways to create a program that will detour all the registry reads.

[withinboredom]

I'm sure there are -- but I'm not doing all of that for a one-off thing.

[munch117]

Wait, can you tell me how to set it for the whole OS? Then please do!