I am using Navision 5.0 SP1 and writing a report to output g/l entries to excel.
All works well except the amounts are coming out raw. i.e. 1450 for 1,450.00.
I would like to output the amount to a fixed 2 position decimal to Excel.
gsTextAmount is a text field 30.
I am using a simple FORMAT command:
gsTextAmount := FORMAT(“G/L Entry”.Amount);
I have tried several options, i.e. gsTextAmount := FORMAT(“G/L Entry”.Amount,30,2); etc. but nothing helps.
Thanks in advance,