Number format in text cell
Try this:
="the projection for the year is "&TEXT(C36,"$#,###")
--
Biff
Microsoft Excel MVP
"Stan" wrote in message
...
I need to import a number from a cell, adding to the text as follows.
="the projection for the year is $"&C36(cell location).
However, i need to format the number with a thousand comma(,) where it is
currently shown as a text ($1234 vs $1,234)
can someone please help?
Thanks
|