Monday, October 05, 2015

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

No comments: