Decimal to string, always format the same, culture independent

EvR

Hi all,

The NAV FORMAT function is still confusing me. All articles I read speak about culture dependent formatting.
But what code should I use if I always want the same formatting of a decimal? It should always be (ie.) '11000.99' as a string. This should not change depending on the current language/culture of the service or client. So I don't want to see '11000,99' when the culture is set to German or Dutch.

Gr, Erik

archer89

please try following
MESSAGE(FORMAT(1234.56,0,'<Standard Format,1>')); // gives number with comma: 1234,56
MESSAGE(FORMAT(1234.56,0,'<Standard Format,2>')); // gives number with point: 1234.56

parm

Hi,
FORMAT will always be culture dependent.
You want to have a culture independent way to represent a number (allways with dot as decimal delimiter and nothing as thousands delimiter).
I suggest to use FORMAT(value, 0 ,9) as xml format and replace the decimal delimiter to your delimiter.

Regards and good luck

parm

archer89

please try following
MESSAGE(FORMAT(1234.56,0,'<Standard Format,1>')); // gives number with comma: 1234,56
MESSAGE(FORMAT(1234.56,0,'<Standard Format,2>')); // gives number with point: 1234.56