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