Can I show a reference value with a string?

B

bokiteam

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.
 
P

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)
 
S

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.
 
Top