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.

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.

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.

Try Format/Cells/Number/Custom

"Total:"* $#,##0.00



In article ,
"L/P" wrote:

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.

That worked except when I go over $9,999.99 it throw the right-sided 9 past
cell line on right.
IOW- the $ does not float to the left,
and the "," is not showing/printing.. Ex: $9999.99 (no biggy).

I don't mean to be "picky", I'm trying to learn how to format.
Should I just play with it(format/formula) or is there an easier way?

Thanks,
L.


"JE McGimpsey" wrote in message
...
Try Format/Cells/Number/Custom

"Total:"* $#,##0.00



In article ,
"L/P" wrote:

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.

The regular Currency format by default doesn't have the $ floating to
the left. However, you can make it float if you put the "* " to the
right of the $:

Format/Cells/Number/Custom "Total:"$* #,##0.00


If the formatted text doesn't fit, try widening the column.

Try playing with the format, and look at the "About custom number
formats" topic in XL Help.


In article ,
"L/P" wrote:

That worked except when I go over $9,999.99 it throw the right-sided 9 past
cell line on right.
IOW- the $ does not float to the left,
and the "," is not showing/printing.. Ex: $9999.99 (no biggy).

I don't mean to be "picky", I'm trying to learn how to format.
Should I just play with it(format/formula) or is there an easier way?