03-05-2019 02:40 AM
Hello I would like to convert a number array with prices into a table string and like to keep the two zeros after the comma if it is an integer number. Is there a tool for that?
Solved! Go to Solution.
03-05-2019 02:52 AM
Hi fsteini,
like to keep the two zeros after the comma if it is an integer number.
Integer numbers don't have a "comma" (aka decimal separator char aka point in English text) by definition. And they always have "zeros after the comma".
Why don't you set the formatting of your numbers to "%.2f"?
03-05-2019 04:03 AM - edited 03-05-2019 04:03 AM
@GerdW wrote:
like to keep the two zeros after the comma if it is an integer number.
Integer numbers don't have a "comma" (aka decimal separator char aka point in English text) by definition. And they always have "zeros after the comma".
In most of Europe, a comma is used as decimal separator (except by programmers).
03-05-2019 04:10 AM - edited 03-05-2019 04:11 AM
Hi wiebe,
In most of Europe, a comma is used as decimal separator (except by programmers).
I know as I live in Germany. And I force my collegues to use "English" settings when they want to handle measurement data…
But in an English-speaking forum it might be obscure to ask about "zeros after the comma".
03-05-2019 05:53 AM - edited 03-05-2019 06:06 AM
@GerdW wrote:
Hi wiebe,
In most of Europe, a comma is used as decimal separator (except by programmers).
I know as I live in Germany. And I force my collegues to use "English" settings when they want to handle measurement data…
But in an English-speaking forum it might be obscure to ask about "zeros after the comma".
Hmm. Not sure about that. I feel it is a serious concern for English-speaking people to be aware of it. If it is obscure, it's about time to change that.
I always (successfully) try to adapt to the people's wishes. If they want comma's, everything that shows should use comma's. Of course, for everything stored, decimal points is a better choice. Reports are a grey area, and it might need a setting to specify what the user wants.
BTW: Getting off topic. %.2f sound like a solution to me.
03-25-2019 10:46 AM
Thank You