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)