How do I format a value when using it within a cell reference tha.
I have a value in Cell B1 that is expressed as dollars such as $52,344. I
would like to format this value within a formula that returns text. For example in Cell B2, I would put ="The sum that is in Cell B1 is "&b1&"." Now I want the value in B1 to be reflected within the results of my formula. I want the result to read: The sum that is in Cell B1 is $52,344. How do I do this? |
="The sum that is in Cell B1 is "&TEXT(b1,$#,##0.00")&"."
-- HTH RP (remove nothere from the email address if mailing direct) "packmule" wrote in message ... I have a value in Cell B1 that is expressed as dollars such as $52,344. I would like to format this value within a formula that returns text. For example in Cell B2, I would put ="The sum that is in Cell B1 is "&b1&"." Now I want the value in B1 to be reflected within the results of my formula. I want the result to read: The sum that is in Cell B1 is $52,344. How do I do this? |
Use the TEXT function,
="The sum that is in Cell B1 is "&=TEXT(B1,"$00,0")&"." "packmule" wrote in message ... I have a value in Cell B1 that is expressed as dollars such as $52,344. I would like to format this value within a formula that returns text. For example in Cell B2, I would put ="The sum that is in Cell B1 is "&b1&"." Now I want the value in B1 to be reflected within the results of my formula. I want the result to read: The sum that is in Cell B1 is $52,344. How do I do this? |
Thanks to both of you. This is exactly what I needed.
"Bob Phillips" wrote: ="The sum that is in Cell B1 is "&TEXT(b1,$#,##0.00")&"." -- HTH RP (remove nothere from the email address if mailing direct) "packmule" wrote in message ... I have a value in Cell B1 that is expressed as dollars such as $52,344. I would like to format this value within a formula that returns text. For example in Cell B2, I would put ="The sum that is in Cell B1 is "&b1&"." Now I want the value in B1 to be reflected within the results of my formula. I want the result to read: The sum that is in Cell B1 is $52,344. How do I do this? |
Correction: ="The sum that is in Cell B1 is "&DOLLAR(B1;3)&"." |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com