In LO Calc, I want to format a number with a dot (".") as decimal separator. My language settings / local settings are and should be German, what forces the comma (",") as separator.
I guess the usage of the function TEXT() is what is needed in conjunction the the NatNum syntax.
But to be honest, I don’t understand how to use it and try and error does not succeed.
I only want to format a floating point number (e.g.: 1,1234) to be displayed/formatted as 1.234, without changing my different global locale settings.