Unofficial Excel Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Sunday, December 14, 2008 – Permalink –

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:
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.
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
excel
Labels: Formats, Tips, Tutorials

<Doug Klippert@ 3:14 AM

Comments: Post a Comment