Let’s say I have a table that I download from my bank statement and want to organise the payments. Problem is that when copy pasting from my bank the format of the numbers is like follows (forces errors when runing f.e. “SUM”);
hi @Miguel_Gomez_Limmert ,
I liked the contributions of @Quentin_Morel and @Pch very much. Like @Pch I hesitated a long time before I dove into the Regex Universe. Since this is actually an other syntax, I’d rather follow the path @Quentin_Morel explored. In the question the idea was to get rid of the last two digits
In my contribution (not a solution) below I keep them because in my perso context this would be more relevant.
This was a very easy to understand solution. Needed this one for formatting numbers from “norwegian system” to “english/international”. This was a perfect fit to change the decimal point from “,” to “.”.
Which again reminds me, perhaps this could be an optional setting within Coda, define your decimal character, and perhaps it could be set as a document standard… Just a thought.