text and formula justify??

  • Thread starter Thread starter L/P
  • Start date Start date
L

L/P

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.
 
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.
 
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.
 
Back
Top