| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Gord and Peo - THANK YOU! That works like a charm.
"Peo Sjoblom" wrote: Try =A1&" "&TEXT(B1,"$#,##0.00") -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "danielo" wrote in message ... Here's a sample of my data: A1: Building A B1: $36,456.00 C1: =A1 & " " & B1 But C1 returns: Building A 36456 And what I want is this: Building A $36,456.00 In other words, the concatenation dumps the "currency" formatting in cell B1, but I want to KEEP that formatting. Can I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
