Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

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.