Can I show a reference value with a string?

[[email protected]]

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.

[goober]

="The price is "&B2+B3

[Peo Sjoblom]

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)


<[email protected]> wrote in message
news:[email protected]...
> 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.
>

[[email protected]]

: )

Thanks.

Best regards,
Boki.

[[email protected]]

: )

Thanks.

Best regards,
Boki.

[Sloth]

you can also use a custom number format like

"The price is $"#,###.00

that way your cell is still a number. It only looks like a string.


"[email protected]" wrote:

> : )
>
> Thanks.
>
> Best regards,
> Boki.
>
>