Change number format from European to British

[khs123]

Is there any functionality within EDT to transform number format from European (eg 2.345.678,987) to British (eg 2,345,678.987)?

[Admin]

Currently there is no specific transform for this and all numbers will be interpreted according to Locale set in Preferences>General. You can do it Replace, but it a bit klunky:

I guess something could be added to Num Format. I will have a think about it.

[khs123]

Thank you for coming back so quickly. I did check Num Format and realised it wasn’t there - guess it’s not an overly requested feature!
I’ll use the replace that you suggest, thank you

[Admin]

Ps/ Numbers are a total mess!

Points or Commas? Decimal Separators By Country | Smartick

[Admin]

We are looking into it now. See:

International number formats

We are looking into trying to handle converting from all the major international number formats in the Num Format transform. These are the formats we are aware of: US/UK style: 1,234,567.89 1234567.89 1.23E6 1.23e6 European style: 1.234.567,89 1 234 567,89 1’234’567,89 1234567,89 1,23E6 1,23e6 Did we miss any?

[Admin]

@khs123 The latest snapshot release now transform numbers with a different decimal symbol to the current locale. Please see:
See: Snapshot release 23-Nov-2023