It's your choice
If you need to format numbers that will be displayed connected to text, here is one way to do it:
- In cell A1, enter the text "You still owe the sum of".
- In cell A2, enter the number "5434".
- In cell A3, enter the text "for invoice # 2232 from 6/15/2001".
- In cell A4, enter the formula =A1&" "&TEXT(A2,"#,##0")&" "&A3.
Formatting concatenated numbers and text
Excel Format Tips
A very well produced examination of the subject by Jon Peltier:
Number Formats in Microsoft Excel
See all Topics