In cell A2 type the following:

="My Text: "&TEXT(ROUND(A1/1000000,3),"##.###")
--
Kevin Backmann


" wrote:

In cell A1 I have the value 10271,623 formatted as a number so it is
displayed as 10.272

In cell A2 I want to display some text and the formatted amount in cell
A1, something like:

="My text: "& A1

If I do it as above it is displayed as "My text: 10271,623" instead of
"My text: 10.272". How can I change that?

Regards,

S