Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a numbers formula used in invoice generation:

="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..."

Which returns:

Invoice terms: 14 days, please pay by ...

Is there a way to apply a style to only part of the formula? I want the outputted "Invoice terms" to be bolded:

Invoice terms: 14 days, please pay by ...

Is this possible?

share|improve this question
    
It doesn't seem to be possible. While you can format the characters in a text cell individually, the format option of a formula cell applies to the whole cell. – fanaugen Apr 19 '12 at 9:34

Formats apply to entire cells and cannot be applied to only part thereof. Can you not put "Invoice terms:" in a different cell?

share|improve this answer

Although one cannot style individual characters in a formula, one feature of Apple Numbers is the canvas. One can take advantage of this by adding tables and text objects anywhere.

Text object example

The above screen shot uses a static (as the OP's "Invoice terms" text is hard coded in their formula example, it is assumed static) text field placed next to the table (a single cell table with no border, in this case) containing the cell with the formula.

The OP's use of the CONCATENATE function is unneeded as the ampersands do the same job. To use CONCATENATE in this case:

=CONCATENATE(Terms,", please pay by...")

Where Terms is the reference to the cell containing the Terms text.

Detailed screenshot:

Concatenate example

By using a number for the days, this can be used in a calculation against the Invoice date to determine the date payment is due. But that is a topic for another question. ;)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.