I would like to format numeric cell double values so that they preserve the number of decimal digits but use a culture invariant format.
Example: I’d like to format all numbers to this format 123456.789, that is no thousand separators and “.” (dot) as decimal separator. The problem is that I want to preserve the number of decimal digits set in the cell properties window.
Now if I just use Cell.DisplayStringValue then I get the correct number of decimals but I also get the culture dependent thousand and decimal separator caharcters, which I want to avoid.
If I use Cell.DoubleValue I can format the number any way I want, but I have no idea how many decimapl digits shall I use.
How may I get around this problem? Any help is appreciated. Simplest would be to find a culture where there’s no thousand separator characters and use a dot as decimal separator.
I attached an XLSX with two columns. The first contains cells with double values, the second contains the text string I would like to turn them to. In order to achieve this I need to know how many decimal places the cells in the first column are set up to display.