Display of numbers in European format

[#1]

Hi,

i have written an expression like this->

=

'€ ' & num(round(sum(INTFULLSTDCOST),.01),'#,##0.00') & ' (' & num(sum(TOTALINVENTORY),'#,##0.00') & ' Kgs' &

')'

I need to convet number display into European format.

I am replacing . by , and , by . in the format like '#.##0,00'

But the thousand seperator is appearing only after last 3 digits and its not recurring further.

How do i get the proper format.

Please help.

Thanks in advance.

[#2]

There will be a default money format set (SET moneyformat=....) by default.

You can override in the formula using money() function. eg. money(amount,'€ ##,##.00') . You can avoid the concatenation of the currency symbol also by this way.

--Arun

[#3]

Thank you.

But my problem is ->

say i have to display-> € 12.345.660,00 (33.450,00 Kgs) (in European format)

I am not able to get that.

in american format its working fine.

but with european format i get like this->

€ 12345.660,00 (33450,00 Kgs)

How do i acheive this?

Please help.

[#4]

when you define a format string for a number, the following characters have a special meaning :

# : a number except when it is a heading or a trailing zero

0 : a number even if it is a heading or a trailing zero

, : the thousands separator

. : the decimal separator

any other characters will appear as themselves

i think you have to set the ThousandSep and DecimalSep variables to the proper value, and use "###,##0.00" as your format string

[#5]

May this work 4 u by adding parameters for decimal adn thousands separator?

money(amount,'€ ##.#0,00;(€ ##.#0,00)',',','.')

--Arun

[#6]

Thank you very much.....