Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formatting a cell to display a word when i enter a reference lette | Excel Discussion (Misc queries) | |||
Formatting the value of a cell reference in a formula | Excel Worksheet Functions | |||
cell reference changes and conditional formatting | Excel Worksheet Functions | |||
Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
How do I copy formatting in a cell reference | Excel Discussion (Misc queries) |