Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I show a reference value with a string?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I show a reference value with a string?
="The price is "&B2+B3 -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=486137 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I show a reference value with a string?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I show a reference value with a string?
: )
Thanks. Best regards, Boki. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I show a reference value with a string?
: )
Thanks. Best regards, Boki. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I show a reference value with a string?
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. " wrote: : ) Thanks. Best regards, Boki. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Looking up a string of text within a string of text | Excel Worksheet Functions | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
Copy a cell to all workbooks within a folder. | Excel Discussion (Misc queries) |