Displaying text and Value with correct format

[Roland Moessner]

Thank you for the help from all of you. When I concatenate
how can I keep the formating used in the value cell, ie.
$5,455.55. Presently, I get Today's total is: 5455.55. I
can include the $ in the " marks but I can't figure out
how to keep the currency formating. Thanks for any help.

Roland Moessner

 

[Peo Sjoblom]

Use

=A1&" "&TEXT(C1,"$#,##0.00")

or

CONCATENATE(A1," ",TEXT(C1,"$#,##0.00"))

 

[cincode5]

Roland... Try editing the formula to read within the cell as follows: (CONCATENATE(A1,etc, etc,etc))*1 and format the cell as needed.

 

[Roland]

Thank you!

-----Original Message-----
Use

=A1&" "&TEXT(C1,"$#,##0.00")

or

CONCATENATE(A1," ",TEXT(C1,"$#,##0.00"))

--

Regards,

Peo Sjoblom





.