Thanks for your help @Connor_McCormick1. The format we need is dot separator for millars and comma for decimal separation.
The problem is: if we need a number like one hundred point ten it wolud be:
100.010 (english format)
100,010 (non english format)
The first option is the only available into coda, and the problem is that everyone in my team, parthers and clients will read this like one hundred thousand ten, wich it a huge problem.
I could divide numbers into before and after separation and then concatenate it but imagine a huge database and then make it ultra big only for this issue. It is not woth the effort, saddly.
There is no right or wrong way to use number formart but actually most of the planet uses a different format, so it something to consider by Coda team if they want to grow up.
Very imaginative @Connor_McCormick1 . Thank you. The problem is, like I said, a huge database with more than 30 colums with this problem and looking up for other tables like this, so, imagine the effort. But I like this “RegexReplace” formula. I did’t know it. Learning something everyday
I will continue to relay this to the product team! Let me see if I can nudge for the date options to be expanded. I am guessing the decimal formatting is a bitt trickier at the moment.
I develop coda docs sharing data in 9 different languages. I can localize the content, but not the headers. Please support the header localization in the coming releases.