problem.
I tried to change General with Currency to get proper format and it won't
take, unless there is something I'm missing.

suggestions please..
L.


"JE McGimpsey" wrote in message
...
One way:

Change your formula to

=C10+D10+E10

and choose Format/Cells/Number/Custom

"Text:"* General

Note: The space between * and General is critical. You can replace
General with another number format.

Note 2: This will convert your value from Text to a Number, and formulas
won't see the "Text:" part.

In article ,
"L/P" wrote:

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.