Format Decimal To String

Business Central/NAV User Forum
1

I have a number decimal: 12.123,123. I want to format this number to string: 12,123.123, because my date need to save field string like this. Please help me!

2

You can use the FORMAT function and “build” your own format string.

3

thanks you so much

4

You’re welcome.

If you check this link:

https://msdn.microsoft.com/en-us/library/dd301059(v=nav.70).aspx

then you find the complete description of how to build your own format string, as it is not one of the standards.