Format number to string

sabzam
sabzam Member Posts: 1,149
edited 2009-11-03 in Navision Financials
Dear all,

I have got number 22 and I need to convert it into text as 22.00 The issue is that it is being converted to 22 only. Is it possible to create it through format or do I need to manually edit the resulting text?

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Yes it is possible, using the FORMAT command, and building your own format string. How to do this is in the C/SIDE Reference Guide, but it's hidden in there. Try searching around in there, see if you can find it. There's a page in there that covers how to build format string for all different data types.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • garak
    garak Member Posts: 3,263
    you can also search the forum for the keywords: format string number zero
    Do you make it right, it works too!
  • frytach
    frytach Member Posts: 8
    Value (Decimal) := 22;
    Result (Text)
    Result := format(Value,0,'<Integer><Decimals,3>'); -> 22,00

Categories