Format Numbers

It's your choice

OzGrid:
Custom Formats

If you need to format numbers that will be displayed connected to text, here is one way to do it:

1. In cell A1, enter the text "You still owe the sum of".
2. In cell A2, enter the number "5434".
3. In cell A3, enter the text "for invoice # 2232 from 6/15/2001".
4. In cell A4, enter the formula =A1&" "&TEXT(A2,"#,##0")&" "&A3.

You still owe the sum of 5,434 for invoice # 2232 from 6/15/2001

Excel Tips
Formatting concatenated numbers and text


Or:



Also:
Excel Format Tips

Also:
A very well produced examination of the subject by Jon Peltier:
Number Formats in Microsoft Excel



See all Topics