| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
keep $ formatting when concatenating
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
