Formatting Number Within Text


Posted by Michael on December 10, 2001 12:56 PM

How do you format a number into currency if it is within text, e.g.:

="The answer is"&G65
gives me the answer:
The answer is 56666.66

I want it to read:
The answer is $56,666.66

Thanks in advance.

Posted by Mark W. on December 10, 2001 1:01 PM

="The answer is "&TEXT(G65,"$#,##0.00") (nt)



Posted by Mike C on December 10, 2001 1:03 PM


Use:
="The answer is " & TEXT(G65,"$#,##0.00")