Formating floating point numbers

spiri

Hi,
I need to format currency numbers like as a spreadsheet:

10      -> 10,00
10.20   -> 10,20
1024.16 -> 1.024,16
9.03    -> 9,03

P.S.- I had to use comma as a point and point as a decimal separator.

Thank you.

cybridz

Try this one:
Format('%.2n', [floating-point variable name]);

PS: %n works depend on your system locale setting
(ThousandSeparator and DecimalSeparator global variable)

spiri

Thank you for your helpl but it doesn't work all the way.

If I use a point as a point it's OK, but since I had to use a comma as a point the function always put a point.

Regards.