EXCEL

Format Numbers

It's your choice

Here is an almost forgotten sample spreadsheet. It was constructed, for Microsoft, back in 1997 by Lori B. Turner, and is still relevant.

The sheets are protected. In order to see the cell formatting, you need to go to Tools>Protection to Unprotect Sheet . . . There is no password required

Formatting sample Workbook

Also:

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