Format () - and integer to string

[LucieLastic]

hi All

This is probably easy but I want to convert an integer (and sometimes a float) to contain decimal separates when a string:

eg

1234567 to '1,234,567' (no decimal places)
7888999.12 to '7,888,999.12'

I need to use the Format function but can't get the format string right.

Grateful of help,
lou

 

[whosrdaddy]

use format('%n',[1234567]);
and format('%.2n',[7888999.12]);

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[LucieLastic]

Done it formatfloat instead

formatfloat('#,0.#', value);

 

[LucieLastic]

Thanks whosrdaddy.

Sorry posted at the same time. Will try your suggestions, though.

many thanks
lou