Thread
:
Formatting a Cell Reference with a Formula
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Formatting a Cell Reference with a Formula
No, I'm afraid that formulas cannot format cells.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"CC" wrote in message
...
Is there a way to make parts of a formula bold and or italic?
"Sandy Mann" wrote:
Replace you reference $K9 with:
TEXT($K9,"$#,##0.00")
and remove the "$" before it.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"CC" wrote in message
...
I have tried to do this and cannot, but my formula is a concatenation of
up
to 7 fields, including both numbers and text. Although I've formatted
the
cells that the concatenated formula is pulling, the dollar amounts are
not
being formatted within the concatenated formula result. Is there a way
to
format dollars within a concatenation formula?
My formula reads as:
=IF(ISBLANK($H9),"",CONCATENATE($H9," - ","(",I9,")"," ",$J9,"
","$",$K9,"
",$L9," "," ","(",$M9,")"))
I would like the dollar field K9 to show as dollars with dollar sign
and
appriopriate commas.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann