Try:

Application.StatusBar = _
"Average=" & format(Round(Application.Average(Target), 2), "#,##0.00") & _
"; " & _
......

This is what I'd use with my USA settings.

If "#,##0.00" doesn't work, then try: "#.##0,00"

I'm not sure how the internalation stuff will work.

In fact, could you post back with your solution. I'm curious.


Jack Sons wrote:

Hi all,

I want the code shown below to give only the sum part its result not in the
format "general", as happens now, but like 123.456,78 (European notation).
I think I should use xxx(Round(Application.sum(Target), 2),2) but I don't
know what function should be in place of xxx. Or perhaps a totally different
way?

Thanks in advance for your assistance.

Jack Sons
The Netherlands

--------------------------------------------------------------------------------------------------------
Application.StatusBar = _
"Average=" & Round(Application.Average(Target), 2) & _
"; " & _
"Count=" & Application.CountA(Target) & "; " & _
"Count nums=" & Application.Count(Target) & _
"; " & _
"Sum=" & Round(Application.sum(Target), 2) & "; " & _
"Max=" & Application.Max(Target) & "; " & _
"Min=" & Application.Min(Target)

--

Dave Peterson