Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  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


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


Excel Format Tips

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

[Edited entry from 10/10/2005]

See all Topics


<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Links to this post:

Create a Link