perhaps do
CONCATENATE(A1,";",Text(FLOOR(A2,0.1),"0\.0"))

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Greetings.

Concatenate function seems to have a bug in Excel 2003 when same sheet
is displayed on a different locale.

For example two cells contain
A1 A2
Hello 10.00%


CONCATENATE(A1,";",A2)

yields

Hello;0.1 (with dot)

and

CONCATENATE(A1,";",FLOOR(A2,0.1))

yields

Hello;0.1 (with dot)

When I send this sheet to Russia where decimal separator is comma not
dot

CONCATENATE(A1,";",A2)

still yields

Hello;0.1 (with dot)

but

CONCATENATE(A1,";",FLOOR(A2,0.1))

yields

Hello;0,1 (with comma)

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