If you want to use a format like currency you need to use the TEXT function

="The price is "&TEXT(B2+B3,"$#,##0.00")

--
Regards,

Peo Sjoblom

(No private emails please)


wrote in message
oups.com...
Hi All,
For a single field, can I show a refernce value (ex: =B2+B3)
and then follow up some strings?

the final result looks like this:

The price is 20

Thank you very much.

Best regards,
Boki.