Formatting numbers - what´s best?

Business Central/NAV Developers Forum
1

Moin: Assumed there are two integers that have to be displayed in a report like this: 01.000022 (the integers are 1 and 22) What´s the most elegant way to realize this? I think the FORMAT statement could help but from my point of view it´s documented poorly. Regards Uwe

2

If the integers are always 1 and 2 characters long respectively how about using STRSUBSTNO? String := STRSUBSTNO(‘0%1.0000%2’,Integer1,Integer2)

3

I dont know if its the most elegant solution, but here’s one: Text := CONVERTSTR(FORMAT(integer1,2)+’.’+FORMAT(integer2,6),’ ',‘0’); Willy

4

Willy:

quote:

I dont know if its the most elegant solution, but here’s one

It works fine, thank you! Maybe there´s someone around here who knows how a FORMAT-string has to look alike to gain the same result without CONVERTSTR. Greetings Uwe