I've tested it with xl97 NL version and YES I see what you mean.
Problems do not occur in xl2003 UK.

So it appears that it's more a matter of Excel Language version
than of ControlPanel locale.

You could either
force numeric fields with N() function.

write a small udf to replace Concatenate.
(for example see
http://groups.google.com/groups?q=au...tcool+gluetext

hth


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote in
groups.com

Greetings.



And there are VLOOKUPs in the sheet, and they all fail because of
this, since CONCATENATE is used to create compound-key field for
VLOOKUP.

Any suggestions?

Thanks