| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
text and formula justify??
I know how to add text to a formula but not sure how/if I can get the results to right justify while keeping the text left justified. Ex. ="Total:" &C10+D10+E10 Would like Total: to stay on left of cell and have results on right formatted as currency. Total: $4567.87 Can I "split" a single cell? Thanks, L. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| formula is displaying as text rather than result. | Excel Worksheet Functions | |||
| Formula in text boxes | Excel Worksheet Functions | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
| Logical Text Formula | Excel Worksheet Functions | |||
Threaded Mode
